ChristofferRexen_1

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

Outcomes