Table references with condition

I have two tables as Workers and Area
How can i show only employed workers in dropdown menu at Area Form.

Workers Table
Jack L.------------Forester-----------------------N
Nick B.-------------Planter------------------------Y
Frank D.-----------Planter------------------------N

Area Form
Dropdown List Elements
Jack L.
Frank D.

In the valid_if use a select expression, something like: Select(workers[Name],[Unemployed]=FALSE)

1 Like