Cannot set table relationship ?!?

  • Thread starter Thread starter Ryan
  • Start date Start date
R

Ryan

I'm trying to use the relationship window to specify a one-
to-many relationship between 2 tables but it wont let me.
One table is linked and the other is local. Is this a
problem? The 'enforce referential integrity' checkbox is
greyed out so I can't set it.
 
For very good reasons, you cannot enforce a relationship between tables in
different databases. The other database hasn't a clue what you are doing in
the first database and therefore can't enforce anything! Put the tables into
the same database and then try.

HTH.

Tom.
 
Back
Top