Delete multiple records

[sandman18]

Please help! I have a multi-table related database. When I delete a record on a list layout, all records with the same company field in that table are deleted. Even when only the record I want to delete is showing (the rest omitted) all records with that company field vanish. For what its worth, the company field is the field that relates to other tables. Any clue why that would be happening?

Thanks,

Sandman18

ps....I'm using FM Pro 9v2

[AudioFreak]

In your relationship set up you have "Delete related records in this table when a record is deleted in the other table" checked.

Michael

[sandman18]

Anyone have a clue on this?

[sandman18]

Sorry, for some reason I did not see the response until now (post was listed with 0 responses)

No, in all the relationships, that setting is not checked.