Conditional value list - simple version
I have a table named 'Workers', with a field 'Worker name'. I have another field name 'Worker department' with for example 'Design' or 'Administration'.
I would like to have a value list, showing only the 'Administration' department workers. I was thinking of a simple way to create a calculation field in the same table, that pre-filters those workers. And then base the value list on that field. Is that possible? And how do I do this?
(there is also the way to create another table, but it seems a bit complicated...)