Ref/enum for specific value

[alhazen]

Hello Guys,

i have two tables in my app which are "data" and "users". I have a column named [producer_name] in table "data" with type enum. The drop down list for the [producer_name] column is only names with producer level from the "user" table, according to the table I attached. so when i fill in the [producer_name] column, drop down list only shows the name with producer level. I need your help how to make it possible. Thank you for your help

name	level	email
John	manager	john@gmail.com
Jenny	supervisor	jenny@gmail.com
Rocky	staff	rocky@gmail.com
Lee	staff	lee@gmail.com
Quality	creator	quality@gmail.com
Jack	producer	jack@gmail.com
Kelly	producer	kelly@gmail.com
Sue	producer	sue@gmail.com

[TeeSee1 · Accepted solution]

In your valid-if or suggested values field, enter the expression below

SELECT(user[name], [level]="producer") 

[alhazen]

Thank you, Master. It works😁