AnsweredAssumed Answered

Question on file import

Question asked by bcf06877 on Sep 15, 2015
Latest reply on Sep 21, 2015 by bcf06877

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?