I'm not sure what you are trying to do.
You can set a option in the relationship so that when you delete a record from Contact, all related records from Referee are also deleted, but I don't know if that's what you want to do or not.
YES exactly what I want to do and have no clue what the "option you mentioned" can be set up.
I'm on FMP 9 Adv, and no triggering of scripts.
If I delete the person from contacts it has to be deleted from the references table (ALL records that have this Contact:ID in the references table).
As you can see I'm clueless...
Thanks for any suggestions .
OK, then we can do this.
Select File | Manage | Database | Relationships
FInd the relationship line that links these two tables.
Double Click it to pop up the Edit Relationship dialog
You'll find some check boxes at the bottom. Click the "Delete related records in this table when a record is deleted in other table" checkbox on the referee side of the relationship.
Abso bloody lutely easy, mate.