C
Chris Burnette
I have an MSDE database with an Access front-end. I have 4 tables in this
DB; one parent and three child tables. The PK of the parent table is used as
a Foreign Key in each of the child tables, and enforce referential integrity
is checked as well as cascade update and delete.
The problem is that when I go to create a new record in the Access front-end
(which uses an Autonumber data type for the parent table PK), the data does
not appear in any of the other tables. This is a problem because I need to
have the same # of records in all 4 tables, and when I create a new record I
need one field (in this case the parent table PK) to be the same for all the
tables so that I can do joins.
Does anyone have any idea why the updates are not cascading? Any help would
be appreciated.
Thanks,
Chris
DB; one parent and three child tables. The PK of the parent table is used as
a Foreign Key in each of the child tables, and enforce referential integrity
is checked as well as cascade update and delete.
The problem is that when I go to create a new record in the Access front-end
(which uses an Autonumber data type for the parent table PK), the data does
not appear in any of the other tables. This is a problem because I need to
have the same # of records in all 4 tables, and when I create a new record I
need one field (in this case the parent table PK) to be the same for all the
tables so that I can do joins.
Does anyone have any idea why the updates are not cascading? Any help would
be appreciated.
Thanks,
Chris