Hi,

I have created database with 2 tables in MSDE using Access 2002 as the front end for MSDE. My question is using Access 2002 as front
how do I create relationship between my tables ?

Thanks

Crete a new access file
select new access project
select existing database
connect to your sql server database from this adp file and that will allow you to do more admin stuf.

do a search on the forum for adp.



Sal

Yes I have the latest service pack SP8 for Access 2002.
I did create ADP project first, then I connected to SQL server and then created a new database, then I put two tables in it with primary keys. And then my problem start, where to click to create the relation between the tables. It is very easy when you have database in Access instead of MSDE, you click on relation icon and link tables.
I think somehow I need to get following screens

http://www.sqlmag.com/Files/09/7633/screen_05.gif
http://www.sqlmag.com/Files/09/7633/screen_06.gif

Have you created database in MSDE using Access and then linked the tables?

Hi there,

In an ADP Project, you can manage the relations through the "Diagram" feature.

Create the database and tables as you described and the follow these steps:

1. Choose Insert | Diagram
2. From the Add Table dialog, choose the tables you want to connect
3. Drag and drop your primary and foreign keys together.
4. Save the diagram
5. Access will offer to update the related tables as well. Choose Yes, so the tables and their relations are successfully saved in the MSDE database.

There may be easier or better ways to do this, but this one does at work fine.

Cheers,

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

Hi, Thanks a lot for your message. I followed the steps you mentioned and was able to create relationship among my tables.