Checking data when importing
Hello FM Forum,
My database has a list of patient records, I get an updated list of patients every month in an excel format from an outside source. I am wondering the best way to import these records in such a way that the data that I have entered will not be changed, but the updated data will be. Is there a way to compare the records as they are importing and have the system ask me which version it ought to import? Also, is there a way to have filemaker let me know when a record has been removed from the excel sheet (patient deceased)?
Each patient has a unique identifier given by the external source. Any thoughts or suggestions would be very welcome.