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.