1 Reply Latest reply on Mar 19, 2010 6:22 AM by JoshJay

    Merging tables and deleting records

    mcconns

      Title

      Merging tables and deleting records

      Post

      Hi,

       

      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.

       

      Thanks,

       

      Stewart