Subforms

[e51lrrp]

I have a POS database. I currently have a frmCustomer, frmOrders, and details of each type of order. Most of the detail forms have lots of fields associated with them. Is it possible to create a new detail form that would include all of the other detail forms? Example, I have types of order for Trophies, Engraving, Embroidery and screen-printing. It is possible for the customer to buy all of these items. Would I use one form with all the other forms being a subform? All the details forms are continuous. Would the order then contain one orderID and would all item numbers be consecutive from subform to subform?

I would appreciate any assistance I can get. Thanks in advance for any and all consideration.
S

[amrut]

Why not add a field for OrderType (Trophies, Engraving, Embroidery and screen-printing) to your order table ?
You can then easily view or print the orders by ordertypes.

[e51lrrp]

I already have this set up what I need to do is allow a customer order that will encompass all the separate order types. s