How to have filtered reference list?

[Rogerio_Penna]

Check this thread RalphGL

How to create a filtered, referenced dropdown list to choose from?

there is a simpler way " You can accomplish that today by adding to the Employees table another column, say, Name_If_Manager with a formula like $Full_Name if $Role == "manager" else "". This will duplicate the Full_Name column but only for managers. Then in the Projects table, set your Managers column to point to table Employees and for “SHOW COLUMN” select Name_If_Manager. This will limit the dropdown to non-empty values, which happen to be only the managers." so here is your first table. …