Enum with values from 2 tables?

[Thilina]

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.

[Suvrutt_Gurjar · Accepted solution]

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

[Thilina]

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

[Suvrutt_Gurjar]

You are welcome. For reference

help.appsheet.com

List Addition

Add lists together to produce another containing all items in the originals.