Quote:
1. If I delete a record, its foreign key record should delete automatically from the original primary key.the foreign keys work with deletions, yes. For example, if you delete a record from Links, then all records in any other table which has a matching foreign key on Links.ID (ie, the Bookmark table) will be deleted as well.
Quote:
2. I should not be able to add a record to the relationship table that does not have a corresponding primary key to its foreign key.If memory serves, insert() and add() do not check this. It's up to you to make sure the relationship is valid prior to inserting the record.
Philip
------------------
Limecat is not pleased.