Hello,
I am having trouble finding a way to append records from table1 to table2 where the criteria in table1 isnt in table2. The problem is there are multiple records with the same field(ID) but two other different fields that I want to check to see if is in the other table. They are Group and Number. I have changed the join where to show all records that are equal between table1 and table2 and all records from table1. For example the data will loook like this:
Table1:
ID Group Number
111 0 000
111 1 100
111 2 100
111 3 100
I can get it to append the records to table2 where fields Group and Number are different but can't figure out a way to append it where it looks for the ID also. I mean it will work the first time because that ID isnt't in table2, but when I append it again with a different Group and Number it wont work because that ID is already in there. I'm trying to make work so it will append that record if all 3 ID, Group and Number aren't in table 2