AnsweredAssumed Answered

Deleting record puts related file records out of sync

Question asked by AdrianWilliams on Jul 5, 2011
Latest reply on Jul 8, 2011 by philmodjunk

Title

Deleting record puts related file records out of sync

Post

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!

Adrian

Outcomes