AnsweredAssumed Answered

Conditional value list - simple version

Question asked by jetserkok on Feb 5, 2015
Latest reply on Feb 5, 2015 by philmodjunk


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...)