What version of Filemaker? What do you mean by 'do not exist'? Do you mean that the names are different? Or that the ID's are different (assuming they are Name ID's, not record ID's)?
How large are the recordsets involved? Do you need to do this once, or regularly? Depending on the answers to the questions above, you could build relationships between matching fields and then grab the non matches, or, for smaller groups, use one of the list functions and poll for losers. John Weinshel Datagrace Vashon Island, WA (206) 463-1634 Member, FileMaker Business Alliance Certified For FileMaker 8 Certified For FileMaker 7 -----Original Message----- From: FileMaker Pro Discussions [mailto:[EMAIL PROTECTED] On Behalf Of Adam Gerson Sent: Monday, May 19, 2008 9:45 AM To: [email protected] Subject: Find all in A that are not in B I have two tables Table A id Name Table B id Name I would like to pull all the records from table a that do not exist in table b I tried adding a relationship between the id columns with the not equals sign, but that didn't work. Any advice? Thanks, Adam -- Adam Gerson Assistant Director of Technology Apple Certified System Administrator (ACSA) Columbia Grammar and Prep School phone. 212-749-6200 ex. 321 fax. 212-428-6806 [EMAIL PROTECTED] http://www.cgps.org Public key - subkeys.pgp.net
