Merging tables and deleting records
Sorry if this has been previously answered. I'm using Filemaker 9.0
I have a table with a list of PC serial numbers and Host Names with an auto-number field to uniquely identify the record.
I want to import a spreadsheet to update this table. The spreadsheet will contain updated Host Names which are matched on the PC serial number field. This step works perfectly using the Import Records function.
However I want to delete records from Filemaker that are not listed in the Excel spreadsheet. I cannot figure out how to do this. Any advice would be appreciated.
You could use a Modification Timestamp and have the script delete anything that wasn't modified within the past few minutes (depending on how long the import takes).