Deleting record puts related file records out of sync
FM Pro 11.. I Have two related files: Contacts file and Produt1 file. The relationship in Product1 file displays instances of ::Name, ::Address, ::Client No. from the other Contacts file.
Deleting a record in Contacts file OR Product file messes things up. I can no longer add a new record and have the relationship work to pass the info between files! What's going on? Why can't I delete a record without completely destroying all the work I've done?
Or can I even prevent anyone from DELETING a record so that any orphaned ones are just left?
In an attempt to understand, I've deleted ALL records in both files and reset the Serial Number to Newxt: 1 in ID fields in both files. I'm guessing that does nothing or even makes it worse? Heeeelp!