I'm trying to set a condition on conditional dropdowns.
If scenario 1 is true, match Value A in this table to Value A in related table,
If scenario 2 is true, match value A in this table, to Value B in related table.
Alternately, I could get away with only one condition but saying, match value A in this table if contained in value A in related table.
IF([some field]="some text",[Value A],[Value B])