I have an Enum list dropdown that links to a Company Name column in a Company table. I also have a Users table where it lists all the users and which company they belong to. These tables are referenced by Company ID.
I would like the Enum list of company names to only show company/companies to which the user belongs to. I’m thinking that the reference does not need to be used here. Maybe just the Users table which only allows choices by userid(). Is there an expression that would accomplish this in the Valid If section? Or other way to get this to work?