I have one table in which I do a weekly import of a tab delimited file. I thought I could just check "Update existing records" because I didn't want to have to delete all records and reimport. Updating does update and does add new records, the only problem is it will not delete records that do not match. Specifically, this is an import of tenants and each month a couple of tenants leave.
And I just had a thought - maybe I'm thinking about this all wrong. Maybe the ex-tenants should not be deleted, but marked inactive or moved to a history table so we have a record of tenants. Any thoughts would be appreciated. I only have 14 months with FM.