relationships between linked tables

[Chris]

Hello everybody,

Does anyone know if it is possible to create a one-to-one
relationship with referential integrity between a linked
and a local table?
In my example: One table (linked) contains general data,
another contains additional information that is of interest
to only one person, hence I wanted to make it a local table.
I then wanted to make a query combining the two and base a
specialized form on it.

Thanks in advance

Chris

 

[Bruce M. Thompson]

Does anyone know if it is possible to create a one-to-one

relationship with referential integrity between a linked
and a local table?
In my example: One table (linked) contains general data,
another contains additional information that is of interest
to only one person, hence I wanted to make it a local table.
I then wanted to make a query combining the two and base a
specialized form on it.

You can define a relationship between the tables, but you can't enforce
referential integrity in any relationship involving linked tables. Any
relationship that you define, in this case, will really only serve to generate
an "autojoin" between the same "related" tables when they are both shown in a
query. Referential integrity can only be set when both tables are in the same
Access (Jet) database and only from within that database file.