Table Relationship in ADP

[Peter]

We connect an ADP to SQL Server 2000.

There is no table relationship being setup in SQL Server.
Is there any way for us to define the relation between a
couple of tables in Access locally ? OR the table
relationship will be updated in SQL Server as well ?

Thanks

 

[Norman Yuan]

In Access ADP project, you can easily create relationship between tables by
using Diagram. Actaully Diagram is SQL Server object, you cannot create
relationship locally saved in ADP file (Forms, Reports, Macros and Modules
are local object saved inside ADP file).

 

[Peter]

In this way, if I create an Access database and link to
the tables in SQL Server via ODBC. Is it possible for me
to create local table relationship ?

Thanks