Rodger,

Alternate names are available in the Constituent Lookup. Note in this
example how a search for "Wilhelmina" returns the constituent "Queen
Caroline" because of the alternate name "Wilhelmina Charlotte Caroline". It
does not display all of the alternate names, only those that meet your
search criteria.

[image: Inline image 1]

The alternate names are grouped under their primary name, and for some
reason I cannot explain, are placed in brackets following an indented
repeat of the primary name.

You have noted a deficiency, in that the tool is looking for Constituents
records, not just name records, so you are correct that if a user did not
know the form of the name they wanted to search on they would need to
perform two searches.

Alternately, you could configure the Alternate Names Display Name field to
display as a distinct value list in Query Assistant.

On Thu, Apr 28, 2016 at 9:33 AM, Kelly, Rodger S <[log in to unmask]>
wrote:

> Thanks, Chad.
>
>
>
> I’ve experimented with this before and came to the conclusion that it’s a
> run-around solution in that it’s not fully functional with Constituent
> Lookup.
>
>
>
> Am I understanding this correctly?  With this method one could use
> Constituent Lookup to see what forms of the name exist, and then switch
> over to QA and search the Alternate Name field on the specific name. Is
> that how you’ve done it?
>
>
>
> Since the alternate name can be assigned to object records, ideally one
> would have the option of bringing the alternate name into Constituent
> Lookup.
>
>
>
> (Sorry. I forgot to mention we are on TMS 2012.)
>
>
>
> Rodger
>
>
>
> *From:* The Museum System (TMS) Users [mailto:[log in to unmask]]
> *On Behalf Of *Chad Petrovay
> *Sent:* Wednesday, April 27, 2016 5:09 PM
> *To:* [log in to unmask]
> *Subject:* Re: Companies with multiple names
>
>
>
> Rodger,
>
>
>
> You can use Alternate Names for this. In the ConXref screen, you can
> select the exact name that you want to use for that object - the primary
> name is selected by default.
>
>
>
> [image: Inline image 3]
>
>
>
> You can also reconfigure your query groups to be able to search on the
> alternate names (to find those with "Gibson Mandolin-Guitar Company") by
> adding fields from the Constituents Alternate Names node to your query
> groups.
>
>
>
> [image: Inline image 2]
>
>
>
> In the past, I've done the same thing with journals in Bibliography, since
> some journals changed their names over time.
>
>
>
> I hope this helps. It was great seeing you at CI! ~Chad
>
>
>
> On Wed, Apr 27, 2016 at 3:33 PM, Kelly, Rodger S <[log in to unmask]>
> wrote:
>
> Dear TMS users,
>
>
>
> If anyone has dealt with varying company names I’d appreciate your input.
> In the musical-instrument world we quite often have companies that used
> different names at different times. For example, we currently have the
> following constituents:
>
>
>
> Orville Gibson
>
> Gibson, Inc.
>
> Gibson Mandolin-Guitar Company
>
> Gibson USA
>
>
>
> These are not Alternate Names per se since they represent distinct periods
> of the company's history. We've been looking for a way to implement an
> umbrella-type term in order for us to retrieve, in this case, all objects
> made by all iterations of Gibson. But at the same time we want to be able
> to limit search results to a specific company name. I've been experimenting
> with the Alternate Names field but I don't think this will work for us for
> two reasons:
>
>
>
> 1. You cannot assign the specific Alternate Name to an object record. (TMS
> assigns the main constituent.)
>
> 2. You cannot limit your search results to a specific alternate name.
>
>
>
> I've also experimented with Parent-Child relationships in the Constituent
> module, but this doesn't seem to accomplish much in terms of search and
> retrieval.
>
>
>
> We are considering adding a master term, in this case, "Gibson", to each
> object record that has one of the constituents listed above. This would
> allow us to search on the master term, and also any of the specific
> iterations of the company.
>
>
>
> If you have done this or something similar I'd love to hear from you.
>
>
>
> Thanks,
>
> Rodger
>
>
>
> P.S. I very much enjoyed CI 2016. Thanks to everyone who was involved!
>
>
>
> *RODGER KELLY*
>
> *Collections Manager  /  TMS (The Museum System) Administrator*
>
> National Music Museum
>
> University of South Dakota
> 414 E. Clark St., Vermillion SD 57069
> http://nmmusd.org
>
> [log in to unmask]
>
> (605) 677-5306
>
> [image:
> http://www.nmmusd.org/signatures/_styles/images/NMM_Logo_String_CMYK.png]
> <http://www.nmmusd.org/>
>
> [image: http://nmmsignature.l-s.com/signatures/_styles/images/facebook.gif]
> <https://www.facebook.com/NationalMusicMuseumUSA>[image:
> http://nmmsignature.l-s.com/signatures/_styles/images/twitter.gif]
> <https://twitter.com/NMMUSD>[image:
> http://nmmsignature.l-s.com/signatures/_styles/images/youtube.gif]
> <http://www.youtube.com/NMMUSD>[image:
> http://nmmsignature.l-s.com/signatures/_styles/images/pinterest.gif]
> <http://www.pinterest.com/NMMUSD>
>
>
>
>
>
> To unsubscribe, send an email to [log in to unmask] with the
> following commands in the body of the email:
>
> signoff TMSUSERS
>
> // eoj
>
> You will receive a confirmation that your subscription has been removed.
>
>
>
> To unsubscribe, send an email to [log in to unmask] with the
> following commands in the body of the email:
>
> signoff TMSUSERS
>
> // eoj
>
> You will receive a confirmation that your subscription has been removed.
> To unsubscribe, send an email to [log in to unmask] with the
> following commands in the body of the email:
>
> signoff TMSUSERS
>
> // eoj
>
> You will receive a confirmation that your subscription has been removed.
>

To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email:

     signoff TMSUSERS

     //  eoj


You will receive a confirmation that your subscription has been removed.