AnsweredAssumed Answered

Value List based on field value

Question asked by JaysonBowles on Aug 3, 2017
Latest reply on Aug 8, 2017 by JaysonBowles

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.