Order Form

[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....

 

[Guest]

Use the AfterUpdate event of the SupplierCombo to requery the ItemsCombo in
the subform. The ItemsCombo in the subform should be based on a query that
filters for the SupplierID on the main form.

I find it easier to have the main form open when designing the query, then
use can use the Builder and list the objects on the load form. Then just
dblClck the SupplierID you see in middle pane of the builder and it will
write the correct link to that field