Does anyone have their db configured for searching alternate names?  In
our set up, if you try searching an alternate name from the objects
module, or if you go into constituents and search "last names," it only
searches the primary name, not the alternate names.  I tried playing
around with the query groups, but when I add "Alternate Names" into the
Query Assistant, it adds another "first name" and "last name" field - so
someone doing a search on a last name wouldn't know for sure if they
were searching primary name or alternate name.

 

So, question 1:  Can I change how these fields appear in the Query
Assistant?  I thought for sure this could be done, but I can't figure
out how to do it.


Question 2:  What if I don't want to separately search primary name and
alternate name?  Is there a way to combine these two searches easily?  I
can do it in Advanced Query, but I'm thinking of our average users who
are scared of Advanced Queries.   

 

Any suggestions?

Thanks,
Amber

the warhol:
Amber E. Morgan
Associate Registrar
117 Sandusky Street
Pittsburgh, PA 15212
T 412.237.8306
F 412.237.8340
E [log in to unmask]
W www.warhol.org 

The Andy Warhol Museum
One of the four Carnegie Museums of Pittsburgh 

Email newsletter http://members.carnegiemuseums.org/email 
Membership http://members.carnegiemuseums.org/SupportCMP