Thanks so much to everyone who has answered my query – it is all incredibly helpful and I will try this out and hopefully find what I need☺

Many thanks!

Kathleen

From: The Museum System (TMS) Users <[log in to unmask]> On Behalf Of Chad Petrovay
Sent: Thursday, May 31, 2018 8:49 AM
To: [log in to unmask]
Subject: Re: Searching alternate names in constituents

Yes, but you are going to have to make changes to your configuration.

Open DBConfig.

Go to "Manage > Query Groups"

Under "Available Hierarchies" open "Objects > Constituent Xrefs > Constituent Xref Details > Constituent Alternate Names"

[cid:image001.png@01D3F8C2.424CF540]

Now add any of these fields to a search group under "Query Groups > Objects" (You may want to create a new Advanced Query group called "Constituent Alternate Names").

Restart TMS and this group and fields will be available for searching.

I hope this helps. ~Chad

On Wed, May 30, 2018 at 6:41 PM, Kathleen Wall <[log in to unmask]<mailto:[log in to unmask]>> wrote:
Hi Everybody

I am trying to clean up my constituent names and one of my constituents has several redundant alternate names. My constituent has over 2,300 records but I have been through all of them and I thought I had corrected all of the names but when I go to delete some of these alternate names, it won’t let me saying there are still records related to that name. Is there any way to search simply on the alternate name so that I can possibly find these records? Every time I do a search on alternate names it just brings up the primary constituent with 2,300 plus records but I am hoping to find the needle in the haystack ☺ so looking for more narrow results.

If anyone has any brilliant solutions for me I would so grateful.

Thanks!

Kathleen

Kathleen Wall
Coordinator, Collections and Resource Centre
Reynolds-Alberta Museum
“A Dynamic Exploration of our Mechanical Heritage”
6426 40 Avenue<https://maps.google.com/?q=6426+40+Avenue&entry=gmail&source=g> P.O. Box 6360
Wetaskiwin, Alberta T9A 2G1
Ph: (780) 312-2080  Fax: (780) 361-1239
[log in to unmask]<mailto:[log in to unmask]>     www.ReynoldsAlbertaMuseum.com<http://www.reynoldsalbertamuseum.com/>

This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail.
To unsubscribe, send an email to [log in to unmask]<mailto:[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]<mailto:[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.