show differences between 2 databases?
Hi, my situation is as follows:
Every month I'll be getting a new spreadsheet from all of my clients. The spreadsheets are simple lists of their customers by customer number. I need to compare the for example "March customers" spreadsheet to "April customers" spreadsheet and quickly pull out the differences so I know how many more or less customers to bill for. Hopefully this makes sense.
I'm importing these spreadsheets to FMP databases.
Thanks for any suggestions.