I'm not sure if this is possible.
I have two lists.
- List A ( for Storage )
- Two columns: Facility, Unit
- List B
- Three Columns: Name, Facility (Choice Type), Unit (Lookup Type)
List A has data that looks like this:
Facility 1 - Unit 1
Facility 1 - Unit 2
Facility 1 - Unit 3
Facility 2 - Unit 1
Facility 2 - Unit 2
The end goal is for a user to come into List B, fill in their name and choose their Facility from a drop down menu. Then the Unit drop down menu should only show the options associate with that Facility - instead of all available units.
I was thinking Nintex would be able to help with something like that.