Hi all, and thanks again in advance.
Can anyone direct me to (or just tell me) the general rules for creating simple queries in Access that allow appending records? (I'd like to know where this is in Access' own Help file, because I know it must be there, but I'm hanged if I know how to ask for it.)
For example, I have a simple two-table query, joined on one column. The column is part of a Key in each table (but not the whole Key in the second table). Table_1 is "Proposals" and Table_2 is "Proposal_Revs". The Key to the first is PropNum, and the Key to the second is PropNum & RevNum.
I've joined other tables before and happily discovered that I could use the resulting queries to add records (had not known before that that was possible in Access, aside from an 'Append Query', which is NOT what I want here) ... but I can't do that with this query. I'm wondering what the rule / rules may be which govern that, but I can't find it in Access Help.