newbe relationship wanted

[swenk22]

I got two similar db's with contact info (name, phone, address) with key identifier ID#. Similar except separated by time/years. I want to identify which contacts have dropped out of the latter db. How do I form a table of exclusive relations- in the 1st but not in the 2nd database? Thanks much!

[bcooney]

1. Create a relationship from FileA to FileB by the key field.

2.Create a calc field,

flag_FileAOnly = if (isempty (FileA::FileB), 1, 0)

3. Find on the flag field, and you'll have the records in FileA that do not have any corresponding match in FileB.