To explain this question a little more.
In a Hierarchial CVL like the example used in Adventures 1 a county can only be in one region and a city can only be in one county.
In my DB each Customer has all the same Type of machines as all the other customers, so when I use the simple Hierarchial CVL I either get all Machines that belong to a Customer regardless of Type (if I match the fkCustomer) or all machines of a Type regardless of the Customer (if I match the fkType).
I decided to use a filtered portal of the Customer's machine that are of the desired type.
Seems to work OK
In reading your post, the same thought came to mind, that a filtered selection portal would work.
However, what you describe does sound like something that could be done with either the
Hierarchical Conditional Value List II or the ExecuteSQL Hierarchical Value list examples as they allow you to select one or both filter values and get a list of values appropriate to what you have selected in both cases.
And I forgot to mention, The #2 adventure file does not have any conditonal value lists. It explores other options for selecting values from a list and I've just updated it to include two more topics to explore.
Thank-you Phil. It’s rewarding to hear you might have handled the problem the same way.
Kutcher Engineering & Inspections Inc.