TMSUSERS Archives

The Museum System (TMS) Users

TMSUSERS@SI-LISTSERV.SI.EDU
Options: Use Monospaced Font
Show HTML Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
Re: manage tables/columns
From:
Christine Droll <[log in to unmask]>
Reply To:
The Museum System (TMS) Users
Date:
Tue, 10 Apr 2018 12:44:12 +0000
Content-Type:
multipart/related
Parts/Attachments:
text/plain (194 kB) , text/html (9 kB) , image001.jpg (43 kB) , image002.png (194 kB) 
The TMS2014 version has it in the Constituents query group. Perhaps “prefix” is also “honorific” or “name title”?

[cid:image001.jpg@01D3D09F.B2CE2C30]

From: The Museum System (TMS) Users <[log in to unmask]> On Behalf Of Eckert, Ian
Sent: Monday, April 9, 2018 5:20 PM
To: [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@01D3D09F.B2CE2C30]

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] with the following commands in the body of the email:

     signoff TMSUSERS

     //  eoj


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

ATOM RSS1 RSS2