Conditional Value List

Discussion created by ChristofferRexen_1 on Oct 30, 2016
Latest reply on Oct 30, 2016 by padje

Hi guys


I'm sure you've all gotten this question a lot of times before, regarding conditional value lists.


I'm working on a database, which includes a User tabel and a Task tabel.


The User tabel holds all the clients using the database, and is all 'born' with a boolean number field called "IsActive", so we can distinguish them from the hired and not hired.


So my colleague made a Value List long ago, holding all records in the User table, regardless of hired or not, to be used in the Task tabel, holding the users ID & Name, from the User tabel, on each specific task the user has ever touched.


Now, I would like to change the value list, since there is no idea of putting inactive people on a value list - right?

So, when I change the VL.


All inactive people only remain with the ID from the User tabel, when active people show as they should.


So my question is:

How do I create this conditional value list, so me and everybody else gets to see the name of the former inactive person, which created the task and not just the ID?


I hope you are following me here.


Best regards