Two back-ends, how define relationships?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mscertified - 02 Mar 2006 16:21 GMT

I have to maintain an application that I did not write and is set up in a
weird way.
There are two back-ends, one is protected by a password and contains a
mini-application to update referenece tables. There are no relationships
defined but there really needs to be as there are several important
one-to-many relationships. The problem is the 'many' side is in one database
and the 'one' side in the other database. Can relationships be defined in
these circumstances?

Reply to this Message

John Spencer - 02 Mar 2006 16:56 GMT

Yes and mostly NO.

Yes: You can set up a relationship that will be used when you open a query
to set default relationship.

No: HOWEVER, to have a relationship that controls the data - enforce
referential integrity, cascade delete, cascade update - the tables must be
in the same database AND the relationships must be set up in the database
containing the tables.

>I have to maintain an application that I did not write and is set up in a
> weird way.
[quoted text clipped - 5 lines]
> and the 'one' side in the other database. Can relationships be defined in
> these circumstances?

Reply to this Message