Link to home
Start Free TrialLog in
Avatar of sandra72
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

Avatar of dtripp7
dtripp7
Flag of United States of America image

what field are you using to define "division"?

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



Avatar of sandra72
sandra72

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
ASKER CERTIFIED SOLUTION
Avatar of dtripp7
dtripp7
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial