How to create field dependency in a record producer?

[Viraj Sapte]

Hi,

I have two fields:
Category and Subcategory
The subcategory field depends on the category selected.
This dependency is set in the incident form and works perfectly.
But I need that to work in SP too.




Thank you in advance.

[Brad Bowman · Accepted solution]

I am doing this with both variables as the Lookup Select Box type, though looking at it now, I'm not sure why Category needs to be this, so maybe first try changing only Subcategory if you'd like.  This allows you to add a reference qualifier that includes the dependency.  Here's what Subcategory looks like

javascript: 'name=incident^element=subcategory^inactive=false^dependent_value=' + current.variables.incident_category

incident_category is the name of my Category variable, which looks similar as a Lookup Select Box, but without the dependent_value part in the Reference Qualifier.  The key to making the Subcategory values update when a Category is selected is the ref_qual_elements attribute which refers to the name of the Category variable.

ref_qual_elements=incident_category