I'm hoping what I am about to ask is possible in some way.
The scenario: there are two lists. The first list is a list of cables that are connected to two rooms.
The building and room columns are lookup fields.
Which building comes first is arbitrary in each room. I.E.
is logically equivalent to
For the second list I want to use a nintex form that can filter a Cable Name drop-down where
it checks against two columns. If a user selects S01 in the Room drop-down, the cable name drop-down will filter to Short Cable or Medium Cable by checking to see if S01 is in Room1 or Room2.
To help explain better here is a diagram:
Currently I can filter where one column matches but I would to include matches against the second column as well.