Linking to different tables based on selected value from a combo box

[dekker]

Newbie Question

I'm making a form to assign a part number based on the values selected
from a series of 8 combo boxes. The purpose is to define and
categorize approx. 30,000 items

The first combo box has 8 fields
if the 1st value is selected
then the 2nd combo box will have 24 possible values, however if in the
1st field value #4 was selected then a whole different table would be
required
this sequence would repeat 8 times to complete a unique 10 character
string

Each selection has the description and it's corrosponding ID and I
would like an output to 2 new fields representing the combined
descriptions and the combined ID's


To get:
1234567890

1=Major Category
2=Product Type
3=Sub Group
4=Material Type
5=Finish
6 7=Size
8=Status
9 0=Price Level

Any help or pointing me in the right direction would be appreciated

Thanks
Dekker

BTW: It looks like I'll end up with about 25 tables to store the
characteristics for these products. Each table will have a minimum of
8 columns up 46 columns

Should I try posting in a different group as well

 

[Joseph Meehan]

I suggest a series of forms. The first selection on from one, that
selection would then open the second form based on the answer to the first.

There are other solutions as well, do you do any VBA?

I think if I understood the problem better, there may well be a better
solution.

 

[dekker]

I don't know any VBA, sounds like it's time to learn, however

If I understand you , this would mean creating 8 different (?) forms
to get a cancontenated value for product number and another for
description. I'm not sure if that is within my ability, but in that
same vein , if the selected value opens another form why not
synchronize each successive combo box so that making a selection in
the current combo box limits the list of available items in the next
combo box.

Just a reminder there are quite a few tables which to choose from that
contain the next set of available items to select from.

To get:
1234567890

as well as description from the 1st 6 combo boxes
1aaaa, 2bbbb, 3cccc, 4dddd, 5eeee, 6_7ffff

1 =Major Category -1 table, 8 items

2 =Product Type - 8 tables, 5 to 23 columns each

3 =Sub Group - derived from 1 of above columns in the selected
Product Type

4 =Material Type - derived from 1 of above columns in the selected
Product Type

5 =Finish - derived from 1 of above columns in the selected
Product Type

6 7 =Size - derived from 1 of above columns in the selected
Product Type

8 =Status - separate table

9 0 =Price Level - separate table