3 Replies Latest reply on Feb 5, 2015 6:33 AM by philmodjunk

    Conditional value list - simple version



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