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

 

[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