Comparing Values Among Many Fields
I have to develop a database which compares two lists of information, among many fields.
Presumably the lists will be made in Excel.
Lets call it list A and list B.
List B will always be the latest.
The list will contain information like SSN, Name, Address, Salery etc.
How do I the most user-friendly way, compare the two lists in FileMaker?
- I want my Database to make a rapport with just the slightest change.
- I want my rapport to be made in Excel to then be imported in my Database.
- I want a list over the records in the Excel-sheet, who haven't been touched at all.
- I want a rapport over the records who already exist in the Database already.
Is it possible?