What is stored in your Active field?
If its just a boolean checkbox or text field with Yes, No then create a new calculation.
Case ( Active = "Yes"; Name ) or if using a boolean checkbox then Case ( Active; Name )
Create your value list based off that new calc field. Keep your calc field indexed.
Thank you so much for your help! Yes I just used a Bolean. But I am quite new to FM. Where should I put the calculation? It seems I cannot put it in Manage Database (where I created the form). Also, "Name" refers the value list, right? I would appreciate it!
File --> Manage Database --> Fields
Create a new field with a calculation type.
Name refers to your customer name field. IF you have seperated out to Last Name and First Name, adjust your calc to comething like: Case ( Active; Last Name " ," & First Name )
You could create a value list to use that calculation field.
I am getting awfully tired of this.
Perfect! I did it. Thanks a million!