A questions about form

[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

 

[Gary Miller]

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

 

[Amy]

Thanks a lot Gary, now it seems all clear to me.
Amy

 

[Gary Miller]

Glad to help.

Gary

Thanks a lot Gary, now it seems all clear to me.
Amy