Order Entry subform

[Rachel]

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

 

[Justin]

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

Here is a link that will help guide you on synchronising combo boxes.

http:\\www.allenbrowne.com/ser-62html

There are other examples on this site that should help you as well. I
know they have helped me on several occasions.

If you have a copy of the Northwind database, you will see one way of
doing what you are referring to.

Hope this helps,

Justin

 

[EddWood]

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

 

[EddWood]

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)