Another newby question - linking multiple rows to one form

[jazztie]

I have this form which shows an order.... linked to this order are the client, the principal company, and the company that carries out the order. The information for these three companies are all stored in one table (since the information is very similar).

Tables look like:
tblOrder
- OrderID
- ClientID * linked to CompanyID
- PrincipalID * linked to CompanyID
- Contractor (company that carries out the order) * linked to CompanyID
- Date
- ...

tblCompany
- CompanyID
- CompanyName
- CompanyAddress
- ...

An example is for instance:
tblOrder
- 1, 1, 2, 3, 01-01-2005

tblCompany
- 1, Comp A, 200 A Lane, LA,
- 2, Comp B, 100 B Lane, NY
- 3, Comp C, 300 C Lane, SF

So, on the form it should read:

Date of contract: 01-01-2005
Client: Comp A - 200 A Lane, LA
Principal: Comp B - 100 B Lane, NY
Contractor: Comp C - 300 C Lane, SF

I understand how to make one link to a form... but how do I make three links from the same table?!?!?

Any help is appreciated!
Jazz

 

[Pat Hartman]

but how do I make three links from the same table?!?!?

Add the lookup table three times to the query or relationship window. Access will suffix the tables as you add them so their names are unique. Then you draw the join lines from fldA to tbl1, fldB to tbl2, fldC to tbl3.