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 |
#2
|
|||
|
|||
Order Entry subform
Hi Rachel,
Have you create any Primary Keys between your tables: i.e. In your orders table have you added a field for CustomersID? As without these in place you will not be able to complete what you are looking for "Rachel" wrote in message ... 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 |
#3
|
|||
|
|||
Order Entry subform
OrderTable (OrderID, OrderDate, OrderTime, TotalPrice etc) Add CustomersID
( Do not use the default ID autonumber for your invoice ID create a new field for that) OrderdetailsTable (OrderID, CategoryID, Quantity,UnitPrice, etc) Add ProductID, SizeID ProductsTable (ProductID, CategoryID, SizeID, ProductName, UnitPrice) |
Thread Tools | |
Display Modes | |
|
|