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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to use many to many join in a database 1
Setting up a PO Form 2
Creating a Search using a combo box and then creating a report. 4
Outlook 365 Signatures 0
Copy previous record into form field 0
Help creating a search form in Access XP 0
Change Form's Recordsource with SQL Statement? 0
"MSysCompactError", "System resource exceeded" & "You do not have the necessary permissions to use the...." 0

Top