Skip to main content

I have two dropdown menus (Department and Cost Center). When a Department is selected I would like to only show Cost Center's related to that department.

 

There are two SmartObjects that pull the data from separate stored procedures. The configuration appears to be correct, but the filtering is not working as expected.

 

Form View

14350i3B15547F3F01BB64.png

 

Stored Procedures

10831i2BC9F310A9128534.png

Dear ,
From wt i see , u only return department name , and cost center name .
In this way , there is no value to use to filter , u need to have the department ID returned to first ddl and useit as value ,
Then to have department ID as foriegn key in cost center and return it to use it at value part .

Note: u r using department name as value and display , u need the ID for the value .

Hope it helps !
Best regards

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings