Many to Many join in a database

G

Gary.

Not sure if this is the news group to post this problem in

The project I am working on is a PO Database
For this discussion the database will have 4 tables
tblPO
tblSupplier
tblProduct
tblSupplierProductTransition

I have setup a standard many to many join with tblSupplier,
tblSupplierProductTransition and tblProduct
What I don't under stand is how to tie them all together
What I need is a form that I can fill out the PO information then select
the Supplier and from their add the Products that I need to order
I am not sure what to do next

Any help would be apprechaited
 
Top