2 Replies Latest reply on Sep 21, 2015 6:47 AM by bcf06877

    Question on file import


      I would like to import a set of records from a CSV file to refresh data in one of my FMP tables. I would like to update records that match on certain fields, and add the remaining records in the CSV that don't match. Got that -- easily done using the FMP import functionality.


      Here's where I need help.. I would like the import operation to also DELETE all the records in the FMP table that don't match records in the CSV import file. I don't see any way to do this using the FMP import function. Is there a simple solution to this problem?