12 Replies Latest reply on Aug 8, 2017 5:17 PM by JaysonBowles

    Value List based on field value


      Hi all,

      This one is driving me nuts.  It's so simple but I can't enact the solution to it, I must be overcomplicating it.  I have a table called Clients.  In this table is a calculation field called Active, it returns a 1 if the client has had a financial dealing with us in the past decade.  What I need is a value list comprised only of Clients with an Active field value of 1.  I can't get it to work and the lightbulb moment of what I'm doing wrong hasn't occurred!

      Any help most welcome.