Creating Relationship with Linked Table

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

Guest

I have an Access table that is linked to an ODBC database. I am trying to
create a one-to-many relationship between this table and two other tables in
the same Access db that are not linked. I've noticed that the check box to
enforce referential integrity or cascade update is not available while
creating the relationships. Is there a way to enforce referential integrity
in this situation?
Thank You,
Jason
 
JasonS said:
I have an Access table that is linked to an ODBC database. I am trying to
create a one-to-many relationship between this table and two other tables in
the same Access db that are not linked. I've noticed that the check box to
enforce referential integrity or cascade update is not available while
creating the relationships. Is there a way to enforce referential integrity
in this situation?
Click to expand...


No. The database engine that manages the data is
responsible for referential integerity. A front end is only
asking the backend db engine to retrieve the data so there
is no way it can be sure that referential integrity is
properly maintained.
 
Ok then - thanks for the info.

Marshall Barton said:
No. The database engine that manages the data is
responsible for referential integerity. A front end is only
asking the backend db engine to retrieve the data so there
is no way it can be sure that referential integrity is
properly maintained.
Click to expand...
 
It is unlikely that you let your users edit straight into the table,
though. And when using a form, there is more at your disposal.
You can use various events on the form and write your own 'referential
integrity' code to enforce it, as long as the user uses the form.
 
Back
Top