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