June 17, 200817 yr Newbies 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!
June 17, 200817 yr 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.
Create an account or sign in to comment