Invalid selection in cascading combo boxes

[dekker]

Invalid selection in cascading combo boxes

or

Using 8 cascading combo boxes to drill down to a specific set of data
where the goal is using the selected values to define a product.

As an example Walmart -100,000 plus items or beter yet The Home Depot
or Lowes.
In The Home Depot trying to classify/categorize each and every item
all the way down to the packaging, how many tables and how would they
be linked if "Green" is used for Paint, Hose, Bucket, Concrete Tint,
or any of the 50 ways you could use Green. Then you 1/4-20 in 3 Grades
and 25+ lengths and the same lengths are not available in each grade.

Now types of paint, lubricants, coatings, coverings............. and
of course TOOLS.

How to construct all the different tables to define a Unique Product
by Classification from the descriptive components of the product?

Example:

Field 1:
Fasteners, Hardware, Handtools, Powertools, Electrical,
Contruction........

Field 2:
Anchor Bolts, Cap Screws, Splices, Coating, Striking Tools ....

Field 3:
Hex Head, Butt Connector, Hammer, Hatchet, Pilot Drill....

Field: 4
Grade 8 Plain, Grade 5 Plated, Plastic, Aerosol, Nylon .....

Field 5:
1/4, Tube, Aerosol, Plastic, Nylon, 16AWG, Cartridge.......

Field 6_7 :
2-1/2", 3ft., 14oz., 55Gal. 200mm,..............

Field 8:
Stock, NonStock, Special, ...........

Field 9_10:
250, 555, 140, 2850, ...........

Each ComboBox selection contains 2 fields/columns. Column_1 has 1 or 2
characters and Column_2 contains a word or phrase.

Keep in mind Field/combo_5 can belong to any or all of the selections
in field_1, but only 3 from field_4. A real mix and match of
descriptive values. Kinda like constructing a sentence and the word
defines the usage or the context defines the word........

Any thoughts on how to construct these fields , queries , tables ?

Thanks
dekker

 

[Nikos Yannacopoulos]

First, you've got to make sure your tables are linked so
as to limit your choices from, say, table2, once you've
made a particular choice from table1. I guess you must
have done so.

Second, your combo boxes need to read from a query that
will restrict your options as per your previous choice. I
suppose you've done that as well.

Third,in order to force the combo boxes on your form to
take into account your previous choice(s), use the "on
enter" event of the combo boxes to requery them (by code
or macro).

Hope this helps...

Nikos Y. (nyannaco at in dot gr)