Forms not working

  • Thread starter Thread starter Neil
  • Start date Start date
N

Neil

I have created a simple 4 table DB and I am now trying to set up a form to
enter data, I am having problems as when I select all the fields I can only
enter data in to some of the fields.... ie if I create a customer address
form it works and a product form that works and an order form that works but
if I create a single form for all three as that covers the info on an
invoice the form wont let me enter say the product info. any help would be
appreciated
 
You need to incorporate subforms. One simplistic approach might be:
OrderHeaderForm
CustomerID
-Customer subform (Customer detail)
OrderID
-OrderDetail subform (Products, and Qty Ordered)
OrderDate
Salesperson
 
Back
Top