AnsweredAssumed Answered

Use LookUp Column to Filter Dropdown Options

Question asked by koolgeex on Apr 26, 2017
Latest reply on Apr 26, 2017 by chaitra.b.c

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

etc.

 

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.

 

Ideas?

Outcomes