Sorry, busy week.

Add two more columns MasterParameter and MasterParametervalue, Master Parameter would only be filled for those columns that have a master or linked parameter that determines their value.

ParameterName ParameterLabel ParameterValue MasterParameter MasterParameterValue

Country Country UnitedStates Continent North America

Country Country Great Britain Continent Europe

Country Country France Continent Europe

Then have the query look for all Country parameters where the MasterParameterValue is Europe, what ever continent ONLY.

Same idea for the project. The populatino of the parameters would be a SQL statement based on your buisness rules for the Parameter selection.