Comparing data in multiple tables

[murraygirl]

I need to be able to compare the data in many fields from one table to the data in many fields from another table and any data that is new or changed needs to be pulled into a 3rd table. I have data listings that are getting huge and cumbersome and so we want to print only what is new or changed instead of everything.

I am new at this and have had no training in FM - my background is in Access and varoius CDC databases so please help if you can and walk me through how to do this if it's possible.

Thanks!

[comment]

Are you importing the new/changed data from an external source?

[murraygirl]

Yes, I am bringing in data output files from Excel and it will be a whole new set of data - including previously entered, new and changed.

Thank you!

[comment]

Why not use the 'Update matching records' method when importing?

http://www.filemaker.com/11help/html/import_export.16.11.html#1027964