Append Query where a condition has to be met

[mkdrep]

I am trying to copy notes from one table to another table where a condition has to be met and I can't figure out how to do that in an APPEND query.:banghead:

Each record has a unique number that comes into my Initial Table in my Access database from a construction program I download. In this particular table both the [DNJTNo] and [DNVersionNmbr] fields can have duplicate numbers. However, when I run the query I want it to add a record to the second table only after the query checks that the [DNJTNo] in combination with the [DNVersionNmbr], is not already in the table. If it is, I do NOT want it appended to the second table. (I have attached a picture of the query in APPEND design stage).
Any suggestions?

Thank you in advance for your help! Mark

 

[jdraw]

I think you should research
unique composite index.
If you made these 2 fields a unique composite index, the database will not allow you to have duplicates.

 

[mkdrep]

I think you should research
unique composite index.
If you made these 2 fields a unique composite index, the database will not allow you to have duplicates.

Thanks for the idea! It seems to have worked perfectly!