Many to many Table design

[samirshah172]

Hello Forum,

In table1, "tblCompany" I have stored All Customers, Suppliers, Service Provider, Transporter etc. Fields are, CompanyID, CompanyName, ...... etc.

In Table2, "tblSaudaBook" i am storing transaction by Fields, S_Num, S_Date,
SupplierID(From tbl 1), CustomerID(From tbl 1), TransporterID(From tbl 1).

I am getting problem while running query of table2 where i want all name from table 1.

Please help me, What mistake i am making.

Regards
Samir

 

[pbaldy]

You would add the company table three times. Join each of the instances to one of the three fields. Access will alias the tables like tblCompany_1, which you can change to something more descriptive.

 

[samirshah172]

Thanks, Work perfect.

 

[pbaldy]

Happy to help!