cascade update not working for all tables related

S

SA

I have a primary table with the foreign keys in it from the subtables. All
tables are setup the same in regards to referential integrity and cascading.
I can enter the initial data for certain tables, but when I want to enter
some additional data (separate subtables) the queries and forms beep at me.
Both instances are setup the same - the working form and the beeping form.
Neither have subforms. I am confused what to try next.
 
K

KARL DEWEY

I have a primary table with the foreign keys in it from the subtables.
Wrong method stated here may be your problem. Subtables would have foreign
keys to match the primary table's primary key.
This way if you change the primary key it will cascade update the subtables.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top