I have a Microsoft InfoPath 2010 form linked to a list at a SharePoint Site. I would like to filter a drop-down list based on the value of a calculated value.
There is a drop-down control which contains values to be picked. These are the
Divisions in my organization; FRD 110, FRD 120 and FRD 130. When a user selects on of these divisions then the
DivisionLong which is a calculated value is set to the Long Name of the Division; FRD 110 = In Service Program, FRD 120 = Readiness and Cyber Security and FRD 130 = Fleet Response.
I then have two option buttons which are Yes / No for a field called
FRDGoal. If the option of Yes is selected then a section is made visible which contains a table with two drop-down controls. The first is
Goal and the second is
Objective. Because each division has an objective 1; I have to have each Goal listed three times. Which when unfiltered the
Goal drop-down contains nine total entries. So in order to not show the goals in the drop-down 9 times I would like to filter the
Goal drop-down by the value of the
DivisionLong so that the Goals are only show 3 times not 9.
If I select the check box in the Drop-Down properties to only show unique entries then the objectives drop-down does not work.