hi to all.. im using access2000. how can i make a query to check if a records does not exist to another table?
tblmaster, tblencoded has both no ID but they have the same fields[ProvinceCode, CityOrMuniCode and Barangay].
anybody have the solution to this problem of mine??

Mabuhay!!!

__________________
Mabuhay!!!

Hi Mabuhay,

Are you simply trying to do a one-time merge of the data in the two tables, discarding any duplicate records? Or are you trying to perform some kind of ongoing lookup?

If you are working with the first scenario, I can walk you through using an append query to accomplish it. If you are trying to do something more complicated, please provide a little more detail.

Regards,

Bob