Subform within a Subform. Is that possible and how? (1 Viewer)

[Sunny Singh]

Hi all,

I have a Color, Color Style Details, Styles, Order Details and
Purchase order table. Color and Style have a Many to Many
relationship, therefore, Color Style Details. Style and Purchase
Orders have a many to many and therefore, Order Details.

The problem is in My INVOICE FORM. This Main form, has a Subform1
where users can choose the Style_No's they want. However, each style ordered, can have many colors and a particular desired quantity that goes with that color and style. So, now, I am trying to put a new Subform2 in the present subform1 that will let the users choose as many colors from the Color Style Details table for the particular styles in each record listed in the Subform1.

Should I be using a tenary relationship between the Color, Style and Purchase Order Tables?

Also whenever I try to put the Subform2 in the
Details section of the Subform1, I don't see it in the Form View. I
have come a long way but am really stuck here.

I appreciate any feedback or help

Sunny

 

[llkhoutx]

Add the sub-sub-form to your sub-form, just like you added your sub-form to your main form.

 

[Pat Hartman]

Rather than make a third level to your order form, stick with the present setup. Just add an additional row if someone orders the same item in two colors. That's what the "big" order entry systems do.

Sweater 2 blue small
Sweater 1 red large
Sweater 1 red medium