sandra72
asked on
Goldmine 6.5
We currently have one Goldmine dBaseIV database that contains two divisions - CB and US and I have created a filter for all CB customers.
One of our sales reps would like to search within the CB filter only but, for some reason, even though the CB filter is active the search will pull records from both divisions.
Is there any way to limit the search to one division?
Thanks, Sandra
One of our sales reps would like to search within the CB filter only but, for some reason, even though the CB filter is active the search will pull records from both divisions.
Is there any way to limit the search to one division?
Thanks, Sandra
ASKER
Ext3 Contains "CB"
The filter is pulling all of the CB records correctly but she would like to be able to perform a search for specific customers within the CB filter only. Unfortunately, when the CB filter is active and she performs a search it pulls customers from US and CB.
Thanks, Sandra
The filter is pulling all of the CB records correctly but she would like to be able to perform a search for specific customers within the CB filter only. Unfortunately, when the CB filter is active and she performs a search it pulls customers from US and CB.
Thanks, Sandra
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
can you copy the filter expression into the forum? (Lookup > Filters > select filter in question and click Properties > copy and paste Filter Expression)
first impression is: sounds like an OR operator in the expression that is making the search less restrictive than desired or could be a parenthesis is needed within the filter expression