Hi all , Hope someone can help.
im trying to put together a small simple database for my local bakers.
I've made 3 tables
Customers , Products and Orders
My problem is i cant seem to generate an order form to input orders using data from customer table and data from the products table
In an ideal world i would like a drop down box to select the customer, then be able to input orders at the bottom of the form by way of a datasheet subform using drop down combo box for products, im getting close but cant seem to get the prices of order lines to auto generate.
im sure my relations are all correct.
very hard to explain everything without doing a wall of text, is there a tutorial that i could follow that is based on customers orders and forms that anyone can recommend ?
my setup
CustomerTable
---------------
PK CustomerID
company
contact
address
postcode and so on
Products Table
--------------
PK ProductsID
product
price
catergory
Order Table
------------
PK OrderID
CustomerID FK
ProductID FK
Quantity
Price
Total
should i have another table for order entry so it could be a subform....please help