Help with Form/Table Design

[mattc66 via AccessMonster.com]

We are in the biz of selling Heaters and Controls.

We want a form that will allow us to bring up a model and show all the
Heaters for that Model and in the Heaters section show a subform of all the
controls that can be used with those heaters.

So my thought was I needed 4 Tables (3 at least).

tblLink
tblModels
tblHeaters
tblControls

or
tblLink
tblModels
tblProducts

There model are basically the KW or Killowatts.
HEATER 4.5
HEATER 6.0
HEATER 8.0

For each model heater they have multiple units dependent on the customer
VOLTS and PHASE
HEATER 4.5
ITEM# DESCRIPTION
9000 HTR 4.5KW 240VOLT 1PHASE
9001 HTR 4.5KW 208VOLT 3PHASE
ect....

Depending on which Heater you choose determins that Controls available.

My plan was to build the 4 Table method with a Relationship from each to the
tblLink.

I then was going to build a Model Table with the subform Heaters but I am
getting stuck There is not a direct link to Model from Heater nor is there a
direct link to Heaters and Controls.

Can anyone give me some advise or direct me to a website with an example of
how to best build something like what I want.

Thanks
Matt

 

[Don Barton]

Hi Matt,
It sounds like you want a form with 2 nested subforms. The main form
would be MODEL, then you would add a HEATER subform with a CONTROLS
subform added to it. The tables would all be set up in the
relationship window as one to many MODELS->HEATERS->CONTROLS
You would build a MODEL form, then build a HEATER's subform with a
CONTROL's subform added to it. Then add the HEATER-CONTROL subforms to
the MODEL form.
I hope this points you in the right direction.
Don

We are in the biz of selling Heaters and Controls.

We want a form that will allow us to bring up a model and show all the
Heaters for that Model and in the Heaters section show a subform of all the
controls that can be used with those heaters.

So my thought was I needed 4 Tables (3 at least).

tblLink
tblModels
tblHeaters
tblControls