I assume you are referring to variables that belong to a Catalog Item, not fields on a table. The best way to approach this is to make your two variables of the type Lookup Select Box. I'll refer to their names in this example as article_category and article_subcategory. The first variable should look like this:
article_subcategory will look similar to this:
Now you just need to go to the sys_choice table and create a record for every category and subcategory value, using sc_req_item for the Table, article_category or article_subcategory for the Element, Label and Value whatever you want, and a Dependent value for the subcategory records. This works without any client scripts due to the ref_qual_elements attribute on the subcategory variable which causes the reference qualifier to be updated when the named variable changes.
I assume you are referring to variables that belong to a Catalog Item, not fields on a table. The best way to approach this is to make your two variables of the type Lookup Select Box. I'll refer to their names in this example as article_category and article_subcategory. The first variable should look like this:
article_subcategory will look similar to this:
Now you just need to go to the sys_choice table and create a record for every category and subcategory value, using sc_req_item for the Table, article_category or article_subcategory for the Element, Label and Value whatever you want, and a Dependent value for the subcategory records. This works without any client scripts due to the ref_qual_elements attribute on the subcategory variable which causes the reference qualifier to be updated when the named variable changes.
