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 wrote:

>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?


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.

--
Marsh
MVP [MS Access]

Ok then - thanks for the info.

"Marshall Barton" wrote:

> JasonS wrote:
>
> >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?
>
>
> 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.
>
> --
> Marsh
> MVP [MS Access]
>

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.

JasonS wrote:

> 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

--
Bas Cost Budde, Holland
http://www.heuveltop.nl/BasCB/msac_index.html
For human replies, replace the queue with a tea