mac, 10.12.3, FMP 11 v 4
I have a pretty basic subscriber DB with name, address, payments, accessing a separate issue DB to figure subscription end dates given start date, and a couple of misc. buttons, like "hold" or "send renewal letter."
Im getting ready to purge a lot of expired subscribers and wanted to save them to a cloned version (subscribers deleted) first.
PROBLEM: when I Save As Clone (no records) what looks like a completely separate file with the new name turns out to be some kind of ghost file with all the records in it. When I deleted all the records in the clone file, all the records from the main file disappeared, too. Same thing when I just made a duplicate file in the folder using the mac system. Deleting records from the copy file deleted from the old file at the same time. Major weird.
Any ideas? this does not seem like correct behavior at all.