Hi,
I was wondering how I could run an append query from table A to table B that only appends data that is not in table B.
I want the primary keys of A to be exactly the same as B, because I will use B as a blank slate (another append query to append info to another table C with all the fields as 0 except for the primary key).
For example,
Table A - Supplier
Table B - Things that supplier does (blank)
Table C - Things that supplier does (information)
Lets say table A has 1,2,3,4 for supplier.
Table B has 1, 2, 3, 4, as primary keys as well but all the other fields are zero.
I insert PK "5" + data into table A through a data entry form, and then when I click on "save" in the data entry form, I want to macro an append/update qry (I don't know which one is supposed to be used in this instance) that will insert PK-5 into table B, so that I can append the blank slate info into table C.
I think I explained this correctly.
Let me know if you have more questions. thank you!
I was wondering how I could run an append query from table A to table B that only appends data that is not in table B.
I want the primary keys of A to be exactly the same as B, because I will use B as a blank slate (another append query to append info to another table C with all the fields as 0 except for the primary key).
For example,
Table A - Supplier
Table B - Things that supplier does (blank)
Table C - Things that supplier does (information)
Lets say table A has 1,2,3,4 for supplier.
Table B has 1, 2, 3, 4, as primary keys as well but all the other fields are zero.
I insert PK "5" + data into table A through a data entry form, and then when I click on "save" in the data entry form, I want to macro an append/update qry (I don't know which one is supposed to be used in this instance) that will insert PK-5 into table B, so that I can append the blank slate info into table C.
I think I explained this correctly.
Let me know if you have more questions. thank you!
