Using Find on Value List returns Unwanted results
When I use the Find View to select by one value on the value list I get the value I wanted plus another value I didn't. How come? How do I stop that from happening?
Can you post an example?
I can imagine several possible explanations but would prefer not to guess.
For example: I have a value list with check boxes including:
and when I use the View->Find View function I click on "Local Press" and my result turns up "Local press" listings and "national press" listings as well.
I tried to constrain the list by finding again on "Local press" "constrain" but I still get "National Press" along with "Local."
I do Find View for "Newsletters" and get only "Newsletters" as I would expect. Same with "Quarterly Publications."
I suspect there may be text in your field that is hidden by the check box format that is resulting in issues when you perform a find.
Just to be sure, I tested a demo file with a check box with National Press and Local Press as the two values and confirmed that selecting National Press in find mode does not find entries only marked with Local Press and vice versa.
Place a copy of your field next to the check boxes, but use Field/control | Setup to format it as an Edit box instead of check boxes. Resize the field to be several lines of text tall.
Now perform your find and examine the edit box formatted field to see if there is any hidden text in your field that's causing the problem.
Hey Phil, I am having the same trouble. I have a field labeled "status" that is based on a value list that contains..
Non Active Client
Any search for Active Client results in showing both Active Client and Non Active Client and visa versa. Any search for Non Client results in showing Non Active Client and visa versa.
What gives? And more importantly how do I stop this. I have tested this with a demo file to ensure there is not some unwanted data stashed in the field.
By the way, if you want to script this exact type of find, it could be:
Enter Find Mode [ Pause ]
Modify Last Find
Set Field [ your field ; "==" & your field ]
Perform Find [ ]
if the person types active client then it will not find non active client this way.
Thank you Luna, that worked.
Retrieving data ...