Multiple Sub Forms

[Nylex]

I have four tables Vehicles Model Colour TintingFilm

I used the Wizard to create a form and sub forms - it creates a Parent form
and two subforms - I need a Parent form and three subforms - it always put
the Colour and tinting Film in one subform

Each form is linked to the form before it - not the Parent form

If I use the wizard to create a Parent and two subforms they are created and
linked together proberly - when I try to add another subform I can not get it
to link properly

Can anybody help

 

[John W. Vinson]

I have four tables Vehicles Model Colour TintingFilm

I used the Wizard to create a form and sub forms - it creates a Parent form
and two subforms - I need a Parent form and three subforms - it always put
the Colour and tinting Film in one subform

Each form is linked to the form before it - not the Parent form

If I use the wizard to create a Parent and two subforms they are created and
linked together proberly - when I try to add another subform I can not get it
to link properly

Can anybody help

Well... the wizards are very limited and presumably were not programmed to
anticipate your specialized needs.

Solution: don't use the Wizard.

Just open the Form in design view, and use the Toolbox Subform tool to add a
subform. Set its Master Link Field and Child Link Field property
appropriately.

I'm not sure I understand your relationships though: what would the
Recordsource of the Colour subform be? Does a vehicle have many colours? If
not, why do you need a subform? What's the structure of the Colour table, and
how is it related to the Vehicle table?

 

[Nylex]

Thank you - that worked

Depending on the colour of the vehicle that is what decides what tinting
film to use on the windows - the vehicle make table has the measurements of
the wsindows and is how we cost and quote on the selling price

Tks again

 

[John W. Vinson]

Thank you - that worked

Depending on the colour of the vehicle that is what decides what tinting
film to use on the windows - the vehicle make table has the measurements of
the wsindows and is how we cost and quote on the selling price

Doesn't sound to me like subforms are either necessary or appropriate! Might
it not be better to just have a Combo Box to select the colour of the vehicle
(again, assuming that two-tone vehicles are not in style at present), and a
second combo - dependent on the first one - to select tints appropriate for
that colour?