Cascading choice list

[Ken Doucet]

I have a list of possible occupations for a person

i.e.
Carpenter
Welder
Trucker
Dozer Operator
Foreman
.......


If Welder is selected then a set of choices should appear specific to Welder
to further refine info on individual

ie 	with rig
	B-Pressure
	CWB
	Journeyman
	etc

If Carpenter is selected then the choices specific to that trade could be

	Apprentice
	Apprentice - Year1
	Apprentice - Year2
	...
	Foreman


The goal would be to provide subsets of choices that are specific to the
initial category selected and if possible to go down to even more levels

ie. Operator /Dozer /specific machinery choices/construction..pipeline/size
of pipeline 18" 24" 30" /


Then a search for all operator/dozer with 24" pipeline qualifications could
be selected. Or a selection based on any one of the choices in the chain
above.


In the original database (DOS) there were 2 fields - 1 with occupation and
the 2nd with a list of all possible secondary choices and allowed all
combinations even though invalid ie Carpenter with rig [with rig is only a
valid selection for Welder]. This was less than ideal since person inputting
had to know the valid options for the category.

Is PopUpDoubleFieldChoices the best way to accomplish this? Since it handles
field and subfield, can I then effectively get what I want by making the
initial subfield the field in another PopUpDoubleFieldChoices?

Or, do I need to look at matrix area of documentation?

Thanks for any guidance.

Ken