Relationships with Backend/Frontend and external SQL db

[mariantrygg]

Hi

I have a db that I have split into FE/BE but which also uses a dozen
or so linked tables from a SQL Server db. I have linked the SQL tables
to the FE *rather than link them to the BE then link again to the FE),
so how do I create relationships between the tables in my BE db and
the SQL tables? If I do this in the FE, are there any issues of
performance, maintainability etc. to watch out for?

Thanks
Marian

[Rick Brandt]

"mariantrygg" <ma****@compsols.fsbusiness.co.uk> wrote in message
news:6f**************************@posting.google.c om...

Hi

I have a db that I have split into FE/BE but which also uses a dozen
or so linked tables from a SQL Server db. I have linked the SQL tables
to the FE *rather than link them to the BE then link again to the FE),
so how do I create relationships between the tables in my BE db and
the SQL tables? If I do this in the FE, are there any issues of
performance, maintainability etc. to watch out for?

You can't create "real" relationships between tables in two different
databases period. Oh, you can go into the relationships window and create
the "lines", but that is all they will be. They cannot enforce anything
and serve only two purposes. They can document how the tables are related
in an abstract sense and they can cause default table joins to occur when
you create new queries. For those purposes putting them in the front end
is fine.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com