Tables setup help needed

[DAmoss]

I have a 'Project' table linked to an 'Output' table (1 - Many).

For each 'Output' record I want it to have 1 to many 'Returns'.

So its a 1 - Many, 1 - Many setup in my mind!

How do I set this up in Access?

Cheers

 

[PHV]

A common way:[tt]
Project Output Returns
------- ------ -------
ProjectID PK OutputID PK ReturnID PK
... ProjectID FK OutputID FK
... ...[/tt]

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[DAmoss]

I'm assumming PK=Primary Key and FK=Foreign Key.

How do I set these up and which ones should I set to Autonumber /number etc; to make this work?

Does anyone know of any samples I can download and examine?

Thanx in advance.

 

[PHV]

Have a look at the Northwind sample database furnished with access:
Customers --> Orders --> OrderDetails

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886