Hello Everyone,
I am having a bit of an issue trying to get an order form to function properly with a subform.
I have several tables designed around various things, that will be utilized in an order.
ProdList (Contains ID, ProductName, ProductPartNo, ProdDesc, BrandID, CategoryID)
ProdBrand (Contains ID, BrandName)
ProdCat (Contains ID, CatName)
OrderHeader (Contains ID, CustID, DateMade, StatusID)
OrderDetail (Contains ID, OrderID, ProdId, Qty, UMID)
UnitsMeasure (Contains ID, UnitMeasure)
What I am trying to create is an order form for multiple rows
The user loads the customer information above and then enters in the items they wish to order
[Qty of Item] [UnitMeasure *Dropdown*] [BrandName *Dropdown*] [CatName *Dropdown based on BrandName Selected] [ItemName *Dropdown based on CatName Selected*] [ProdPartNumber *Based on ItemName*] [ProdDesc *Based on ItemName*]
======
Any thoughts on the best way to go about this and allow them to enter in new OrderDetail rows, while utilizing information across multiple tables?
Thanks,
Steven