comparing 2 lists

[agtjazz]

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, 2008 by Guest

[bcooney]

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.

[comment]

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.