I have created an InfoPath form and also a list which is used to populate a drop down list. I need to conditionally populate my drop down depending on the value of the current field.
This is my List
1 Awaiting Action
2 Process Commenced
3 Awaiting 1st Manager
4 Awaiting 2nd Manager
5 On Hold
6 Document Accepted
7 Document Rejected
On initial load of my form I want to show all entries.
On subsequent loads I need the drop down to only contain certain information, depending on the current status.
If the current status = “Process Commenced” – I do not want to show “Awaiting Action”
If the current status = “Awaiting 1st Manager” – I do not want to see “Process Commenced” or “Awaiting Action”