Goldmine 6.5

Posted on 2006-06-05
Last Modified: 2013-11-24
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

Question by:sandra72
    LVL 3

    Expert Comment

    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


    Author Comment

    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
    LVL 3

    Accepted Solution


    you can obtain the filter results with the drill down feature

    select the CB filter but run Search All instead of Activate
    click Build Filter (with the Search window still populated)
    click the AND key and enter the contacts (or other fields) to search for
    click Insert Condition > click OK
    click Drill Down to apply the contact search to only the results of the CB filter

    you can then click Save and save as a new filter (give it a new name)
    it will also Activate the revised search results once you save

    check out the following link:

    even when you activate a filter, certain find, search and activity functions still search the entire contact set

    the drill down function gives you a secondary search limited only to the CB filtered records

    let me know if you need more detail


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    When CRM stops functioning propperly or mysteriously disappears then this is something you should always check. This can be useful when looking at an end users machine or your own machine if you are the end user. It may be fairly obvious to some but…
    Messaging apps are amazing tools with the power to do a lot of good, but the truth is the process of collaborating with coworkers requires relationships established through meaningful communication - the kind of communication that only happens face-…
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now