I have two lists of students (list A and list and want to compare them to find out which students from list A don't exist in list b. These were excel lists that have been imported into separate tables in Filemaker.

Any advice would be greatly apprecaited.

Edited November 18, 200817 yr by Guest

If you have FM9A, you could use Ray Cologon's custom function XORvalues . Perhaps, just looking at some of the list custom functions will help.

Define a relationship between the two tables on a field (or fields) that uniquely identify the student. Then you can find which records do not have a related record by searching the related field. Or by a script that shows all records in one table, does Go to Related Record [ other table, match found set ], Show Omitted Only.