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.