Thanks Ian! I would have never thought to look there! Christine, you are correct. There is a Suffix in Con records, but there is also a separate Suffix (and Prefix) in ConXref Details, which is entered in the Constituent Assistant screen when linking records.
Best,
Christina
From: The Museum System (TMS) Users <[log in to unmask]> On Behalf Of Christine Droll
Sent: Tuesday, April 10, 2018 8:44 AM
To: [log in to unmask]
Subject: Re: manage tables/columns
The TMS2014 version has it in the Constituents query group. Perhaps “prefix” is also “honorific” or “name title”?
[cid:image001.jpg@01D3D18E.39DB4930]
From: The Museum System (TMS) Users <[log in to unmask]<mailto:[log in to unmask]>> On Behalf Of Eckert, Ian
Sent: Monday, April 9, 2018 5:20 PM
To: [log in to unmask]<mailto:[log in to unmask]>
Subject: Re: manage tables/columns
Christina,
I believe these are located in the 'Others' section of Tables/Columns, under Constituent Xref Details:
[cid:image002.png@01D3D18E.39DB4930]
All best,
Ian
On Mon, Apr 9, 2018 at 6:05 PM, Christina Gibbs <[log in to unmask]<mailto:[log in to unmask]>> wrote:
Dear ListServ,
Is anyone able to locate where the Prefix & Suffix fields (from ConXrefDetails) live in manage Tables/Columns? I would like these to display as a distinct list in queries for a manual data scrubbing project.
Thanks!
Christina Gibbs
Collections Database Manager
Detroit Institute of Arts
5200 Woodward Avenue│Detroit, MI<https://maps.google.com/?q=5200+Woodward+Avenue%E2%94%82Detroit,+MI&entry=gmail&source=g>
313.578.1051 │ [log in to unmask]<mailto:[log in to unmask]>
Discover the connection between character and costume.
Tickets are now on sale for Star Wars™ and the Power of Costume<https://www.dia.org/starwars>, May 20-Sept. 30
Developed by the Smithsonian Institution Traveling Exhibition Service in partnership with the Lucas Museum of Narrative Art and in consultation with Lucasfilm Ltd.
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.
--
Ian Eckert
Manager, Collection & Exhibition Technologies (CE-Tech)
The Museum of Modern Art
11 West 53rd Street New York, NY 10019
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.