If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Order Entry subform
Ok - I am going around in circles with this one! I know it has probably been
answer a number of times and there are a few examples out there but I just can't seem to get it to work on my database.... this might be a bit long winded for a very simple answer but here goes..... I am trying to create an order entry subform to input orders for my customers. I have: CustomerTable (ID, FirstName, Surname etc) ProductCategoryTable (CategoryID, CategoryName) ProductSizeTable (SizeID, SizeName) ProductsTable (ProductID, Category, Size, ProductName, UnitPrice) OrderTable (OrderID, OrderDate, OrderTime, TotalPrice etc) OrderdetailsTable (OrderID, CategoryID, ProductSize, ProductName, Quantity, UnitPrice, etc) Do I need to use a query to create the subform from? I want to use combo boxes to select category, then size then product and for it to then populate the price etc. I am struggling to get the combo boxes to display the correct information from the correct source. Do I use the CategoryTable for the cboCatergory control source or the ProductsTable, or the OrderDetailsTable? How do I synchronise the combo boxes? I can't get 2 combo boxes to synchronise let alone 3! And then how does it all get saved back to the OrdersTable and then linked to the Customer? Ahhh! Any help is much appreciated Thanks, Rachel |
Thread Tools | |
Display Modes | |
|
|