Comparing Imported Excel Files with Current Database
Hi! I am on the staff of a Collegiate Marching Band and we have recently picked up FileMaker Pro to help with our membership database. Everyday we have to cross-reference our class roster to see if anyone have added OR dropped the course from their schedule. We recieve this information in an excel spreadsheet. Is there any way for us to import this data and see records that are NEW and have been DELETED from the source file. We need this information in order to contact the members as soon as possible. We are hoping that there is a way for FMP to do this for us instead of doing it by hand. We basically just need to do a complete comparison of two lists/databases/tables. Any ideas?