How can I create a value list based on selected records?
Hello, I have a Customer table with a field named Active (active customers) and I need to create a value list only consisting of Active customers. How could I do it? Please help.
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.
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.
Here's a thread on setting up conditional value lists:Custom Value List?
Mr. Vodka is describing "option 1"
I am getting awfully tired of this.
Retrieving data ...