Multiple hierarchies

[E Gish]

I am continuing on my quest of a single file solution and have a products table with which I need to do conditional value lists on several fields. The fields are as follows:

Class, Manufacturer, Model, SerialNr, Category, Subcategory, ActiveStatus and ProductName

In FM v5.5 I built relationships starting with a Keyfield and compared it to a global field for conditional relationships

KeyClass=Class

KeyClassManuf=KeyClass & Manuf

KeyClassManufModel=KeyClassManuf & Model

etc...

same method with globals

gClass=Class

gClassManuf=gClass & Manuf

gClassManufModel=gClassManuf & Model

etc...

then I built the relationships

gClass=KeyClass

gClassManuf=gClassManuf

gClassManufModel=gClassManufModel

etc...

This gave me the ability to do the drill down method of sorting the products by fields with conditional value lists that in the end reduced the lat value lists to a dozen or so compared to 6000 entries.

I am wondering if FM& will allow me to do a much cleaner method of doing this without building all those fields and relationships?

I do not see the mupltiple comparators in relationship builder helping, but maybe I am wrong in this.

Perhaps there is another method to do it as well. I hope this is clear

Thank you all for your help.