Enum with values from 2 tables?

Hi, I want to know if there is a way to get values for a valid-IF in an enum column from 2 tables

eg:Item either sent to a 3rd party company or another branch, 3rd Party companies stored in one table “Courier Companies” and other branches stored in another table “Branches”

Any help would be greatly appreciated. :smiley:

Yes, you could try in valid_if

Courier Companies[Company] +Branches[Branch Name]

Assumes [Company] and [Branch Name] are identical type of columns -such as Text or Name

2 Likes

Worked like a charm thank you very much! I had no idea you could use it this way :smiley:

2 Likes

You are welcome. For reference

3 Likes