I'm working on an Access project that I took over from a co-worker. There are three tables that exist: `rules`, `overview` and `relationship`. The `relationship` table has two fields, each is a foreign key that links to a primary key in the other two tables. I have a datasheet view of the `rules` table in a form, where I can delete records with no problems. However, when I try to insert a record into the `rules` table, the record will be inserted into the `rules` table, but there is no matching record inserted into the `relationship` table. I have "Enforce Referential Integrity" checked, as well as "Cascade Update Related Fields" and "Cascade Delete Related Records". I made a naive assumption that this would handle inserts, but clearly I was wrong. So I'm now wondering about the best way to handle this - do I write some VBA for the `After Insert` event of the form that inserts a record into the `relationship` table accordingly?