combo boxes

  • Thread starter Thread starter Gary
  • Start date Start date
G

Gary

I am working on this database that has a table ( tbl_main ) with the
following 3 fields (amongst many fields in the table): Product, PanelType
and Thickness

Product (text field - combo box containing values to choose from)
The product field has (from the drop down box) the following values to
choose from:
KS1000
KS1000RW
KS900
KS600

PanelType: (text field - combo box) ie:
MR (this selected item relates to products KS600 KS900 KS1000 )
EB (this selected items relates to product KS1000RW )
CX (this selected items relates to product KS1000 )
MM (this selected items relates to product KS1000 )
WV (this selected items relates to product KS1000 )

Thickness (number field - combo box containg number values to choose from).
Values to choose from:
40
50
60
75
80

Each product contains certain thicknesses in the range and certain
paneltypes relate to it:
ie KS1000 only comes in 40mm 50mm 75mm and paneltype MR is the one
associated with it.
KS600 comes in 60mm 80mm
I would like to be able to setup a form with a combo box that recognizes
that if choosing KS1000 from the dropdown box, it will then give you a
choice of the respective paneltype associated with it and also the 40 50 and
75 thickness ranges to choose from.
Once selecting the paneltype/thickness, it simply allocates these values
(product,paneltype and thickness) in their respective fields to the record
in question.

P.S. I only have one table for the database - I am not that great at
primary keys/relationship links
So my other dilema is that for a given record - more then one product could
be chosen. So i've gone ahead and created fields like: Product1 Product2
etc to cater for multiple product selections for a given record.
Any advice ? thanks.
 
Gary

Based on your description, your table includes "lookup" type fields. A scan
through the tablesdbdesign newsgroup will reveal a strong consensus against
using this type of field.

What you are describing is quite doable, but not from within an Access/JET
table. In Access, tables store data, and forms display data.

Create a form, add your three combo boxes, and look for Access/HELP, or
mvps.org help, or Google.com help on "cascading combo boxes".

Note:

If each combination of Product, PanelType and Thickness needs to be unique,
you'll need at least another table -- take a look at the cascading combo
boxes explanation to see how you'd use this.

Regards

Jeff Boyce
<Access MVP>
 
Back
Top