Cannot set table relationship ?!?

[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.

 

[tom]

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.