Delete Record issue

[G. Smith]

Help.

I am using FMP 7.0 v3. I have a database with several tables. When I attempt to delete a single record in one table, FM deletes all records from that table.

Performing the same operation on other tables within the database, only the highlighted record is deleted.

The issue is teh same whether the records are sorted or all records are showing. Baffled why the impact is only one one table and how to fix this problem so I can properly delete appropriately selected records?

[LaRetta]

I wonder if you have a self-join based upon the Cartesian operator? And if you have selected 'Allow Deletion of Related' within the Relationship Dialog?

Otherwise, is your Delete Record scripted? If so, you might check that. But I suspect a relationship deletion taking place somewhere.

LaRetta