I've stored all the data in an external .mdb. I setup relationships between the tables in the external .mdb file, setting 'Enforce Referential Integrity', 'Cascade Updates', and 'Cascade Deletes'. They are mostly left-join relationships (type-2).
I made links to the tables in the the second, interface, .mdb. The relationships that appear in the interface .mdb file don't show the 'cascade updates' and 'cascade deletes' options and I can't get at them to add them. The info box at the bottom of the relationship window says "one-to-many (external)".
I've made a select query using two of the linked tables to display info in my main form. When I delete a record in the form, the dialog box asking if I'm sure I want to delete the record appears and I say 'yes', and the form updates without the record. When I reopen the form, however, the record has returned. I've tried removing the second table in the query, and the delete works just fine, including the cascading deletes.
I've exhausted the help files and books24x7.com and I can't find a reference to this behavior. I know I'm missing *something*. Can anyone help? Thanks so much, in advance!!!!!
I made links to the tables in the the second, interface, .mdb. The relationships that appear in the interface .mdb file don't show the 'cascade updates' and 'cascade deletes' options and I can't get at them to add them. The info box at the bottom of the relationship window says "one-to-many (external)".
I've made a select query using two of the linked tables to display info in my main form. When I delete a record in the form, the dialog box asking if I'm sure I want to delete the record appears and I say 'yes', and the form updates without the record. When I reopen the form, however, the record has returned. I've tried removing the second table in the query, and the delete works just fine, including the cascading deletes.
I've exhausted the help files and books24x7.com and I can't find a reference to this behavior. I know I'm missing *something*. Can anyone help? Thanks so much, in advance!!!!!
