How to show Removed and Added records?

[ML2008]

I have an Excel file with a list of 2,000 properties dated January 2009 and have a separate list with 2,200 properties dated September 2009.

How can I use Filemaker to show the properties that are on both lists and the properties that on one list but not the other?

Actually a need to separate the properties into three categories, NoChange, Removed, Added.

The fields are Property Ref (unique), Property Name, Property Size and the list date.

[Vaughan]

Import both Excel files into separate tables in a FMP file. Create a relationship between the two tables based on the "property identification" field*.

Create portals that display the related records, from which you can deduce the information you need.

*This is probably the trickiest part. The properties need some identifier that is unique to each, and identical for all that are the same.