Urgent Help - FMP Deleting Records

[bpcstaff]

I have a database with two main tables - individuals and companies.

We just discovered that every time we delete an individual record, FMP deletes ALL records with the first and last name (even though each record has an individual serial #) -

So if I create three records with the first and last name fields as 'Jane' 'Doe' and delete one record (either through a button or through Ctrl E), all Jane Does disappear - even though they have unique Contact ID's and are associated with different companies.

I don't have this problem in the Company table -

I'm a relatively advanced FMP user, and I can't for the life of me figure out what's happening, here.

Any assistance would be greatly appreciated... this is pretty urgent.

Thank you!

[bpcstaff]

I should add that this happens if I run a search for all Jane Doe's or am showing all records - it doesn't matter.

Additionally, the delete button isn't in the header - it's within the body of the record.

[Vaughan]

It sounds as though there is a self-join relationship that uses the name as the match field, and it's set to delete records.

[Jack Rodgers]

Does the Delete button perform a script something like:

Find all fieldname = fieldname

delete all records

?

[bpcstaff]

Right you are - I thought it had been deleted, but no - thank you so much!

[bpcstaff]

Hey, Jack - actually, it was a self-join relationship causing me grief - but thanks!

[Cyphran]

Thank you for this! I have been frustrated with a similar issue for a couple months now and located a self-join relationship I created when I originally designed the database that is no longer used for anything. This is why clean programming is important...

[Vaughan]

"This is why clean programming is important..."

.. and thinking very carefully before the "delete" option in the relationship is selected. }:(