Linked Tables. Get RelationShips from server

[Franck]

Hi,
I'd like to know if it's possible to get server side relationship when
building Link Tables in my AccessFront End.

Basic Sample :
In my Sql Server 2005 DataBase, I've got Table2 which is linked to
Table1 with a foreign key.
When I add them to my Access Front End, I can't see the relationship
in the... relationship diagram.

Can I do this in any way ?
Is it useless as soon as the relationships are defined server side ?

Thks for your help.

[Rick Brandt]

Franck wrote:

Hi,
I'd like to know if it's possible to get server side relationship when
building Link Tables in my AccessFront End.

Basic Sample :
In my Sql Server 2005 DataBase, I've got Table2 which is linked to
Table1 with a foreign key.
When I add them to my Access Front End, I can't see the relationship
in the... relationship diagram.

Can I do this in any way ?
Is it useless as soon as the relationships are defined server side ?

Thks for your help.

You would have to add them manually to your front end, but it would be just
for documentation. About all it will DO is automatically add those joins
when you build queries.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com