cascade update not working for all tables related

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
Back
Top