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.