Dear ,
its fine , u could also filter in another way , well , when you need to set the data source as the third table smart object "many to many"
im nt rly sure from where u get the departmentID value , but oh well ill assume its already in ur smartform somehow in a text box or data label ,
so u need to go to the view initialize method , there u will find a rule "Populate list control (ur drop down list) with data" , configure that rule
u will find "filter" part inside , go there and add a new filteration , which is "DepartmentID" = (the value for departmentID on ur form)
-note : that case will work that way only if the departmentID is already there on ur smartform before the initializing .
the second scenario could be that u send departmentID from previous form to this Form , which will make 1 modification , which is
if u send department id from previous form to this form into a datalabel or textbox ,
all u need to do is delete "populate list control with data" from view initialize and move it to another rule ill show now
"when a control executes a method " method is changed , and the control is the data label u receive departmentID in .
inside this rule u will need to re add that "populate list control with data" rule .
to make sure u filter the population with departmentID is nt empty .
Best regards .
