Allow user to link a common field in a form to a select list
I have several multi-select lists that have a common field - Facility. But the only way to use them would be to combine them into a larger multi-select list. For instance I have a list of Pay type codes and a list of Supervisors. At the top of the form the facility is chosen and I am using that to pull the pay types. I'd like to also limit the Supervisor list to the facility as well. Maybe a way to associate a Form Field to a field in the select list when you click Filter. Then a choice to associate a field in the filter with a field in the form.
ie: FacCode = Form Field Facility
1
vote