AnsweredAssumed Answered

Merging tables and deleting records

Question asked by mcconns on Mar 19, 2010
Latest reply on Mar 19, 2010 by JoshJay


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.