Hi Amber,
 
When you use 'Keyfields' in the constituent lookup in Find Object, it searches across constituent name fields (first name, last name, institution, nationality and so forth) as well as all alternate names.
 
Jeri

Jeri L. Moxley
Manager, Collection and Exhibition Technologies
Collection Management and Exhibition Registration
THE MUSEUM OF MODERN ART
11 West 53rd Street, New York, NY 10019
T:  212.708.9599  I  F: 212.333.1102  I  [log in to unmask]
PPlease consider the environment before printing this email.

 
 
-----Original Message-----
From: The Museum System (TMS) Users [mailto:[log in to unmask]]On Behalf Of Morgan, Amber
Sent: Wednesday, February 25, 2009 3:58 PM
To: [log in to unmask]
Subject: Searching alternate names

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