D
DB
Apologies if this sounds too brief/complicated etc...
Need an order form, whereby user selects a supplier and then can choose only
items from that supplier. OK, so I have a table "tblOrder" which contains
the fields "OrderID" and "SupplierID" (as well as things like "Date").
Created another table "tblOrderSub" with the intention of creating a subform
in the order form to choose the items with. But, I can't figure out which
fields to link to what so that it filters only to items which the selected
supplier stocks?!
Apologies for my lack of technical vocabulary/expertise, I'm new to this.
Thankyou VERY much for any help....
Need an order form, whereby user selects a supplier and then can choose only
items from that supplier. OK, so I have a table "tblOrder" which contains
the fields "OrderID" and "SupplierID" (as well as things like "Date").
Created another table "tblOrderSub" with the intention of creating a subform
in the order form to choose the items with. But, I can't figure out which
fields to link to what so that it filters only to items which the selected
supplier stocks?!
Apologies for my lack of technical vocabulary/expertise, I'm new to this.
Thankyou VERY much for any help....