A questions about form

  • Thread starter Thread starter Amy
  • Start date Start date
A

Amy

Hi there:
I have 3 forms called Customers, Orders and Order Details.

Customers (one to many) Orders
Orders (one to many) Order Details

Now, I create a form, shows Customers as main form, and
Orders and Orders Details as sub forms.

How do I choose for example. Customer John Greschner, what
he ordered and the order details will pop up, that I can
keep on entering new orders. What happened now is that
when I choose John Greschner, only the main form (which is
Customers) associate information comes up, the rest of the
forms don't show any changes.

Can anyone help me on this?

Thanks,
amy
 
Amy,

The normal setup for adding orders is to create an Order
Form as the master with Order Details as the subform. When
you enter a new Order, you pick the Customer from a dropdown
list and store the Customer ID in the Orders Table. It is
not a usual practice to enter orders from the Customer Form.


If you are wanting to review all of a customer's orders, you
can do it with a report, or by filtering the orders to the
customer, or through another form designed for that purpose.

Gary Miller
 
Back
Top