1 Reply Latest reply on Oct 30, 2016 11:54 PM by padje

    Conditional Value List

    ChristofferRexen_1

      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