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?