Setting up a PO Form

[Gary.]

I am working on a P.O. form and have run into a problem that I haven't been
able to fix
I have 5 tables
Table Joins are as followers
tblPO(1 to Many) tblSupplierTrans
tblSupplier (1 to many) tblSupplierTrans
tblSupplierTrans (1 to many) tblProductTrans
tblProduct (1 to many) tblProductTrans
What I would like to do on my form is when the supplier is selected that it
only shows the Products that apply to that supplier
In the form in enter the PO Date and Number then I go to a sub form where I
select the Supplier, that form has a sub form where I select the products
for the supplier
In all of the examples I have seen of Inventory or PO forms are the same
way when you select the supplier and go to select the products you a list
of all of the suppliers not just the products for the supplier selected
Thanks for you Help

 

[Klatuu]

It sounds like you don't have your Link Master and Link Child Fields
properties set up for the second subform control.

I don't see anywhere in your tables how you identify which product a
supplier offers.

 

[Gary.]

It sounds like you don't have your Link Master and Link Child Fields
properties set up for the second subform control.

I don't see anywhere in your tables how you identify which product a
supplier offers.

Thanks for you reply How should it be set up? I keep coming to a dead end