Hello everyone, Could anyone tell me how to change an accession number that has been incorrectly entered? Many thanks, Jennie Smithken-Lindsay Collections Manager History Associates Incorporated 300 North Stonestreet Avenue | Rockville, MD 20850-1655 Tel: 301-279-9697 Fax: 301-279-9224 [log in to unmask]<mailto:[log in to unmask]> www.historyassociates.com<http://www.historyassociates.com/><http://www.historyassociates.com/> Privileged/Confidential/Proprietary information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of this message to such person), you may not copy or deliver this message to anyone. In such case, you should destroy this message, and notify me immediately. If you or your employer does not consent to internet e-mail messages of this kind, please advise me immediately. ________________________________ From: The Museum System (TMS) Users [[log in to unmask]] On Behalf Of Essam, Gillian [[log in to unmask]] Sent: Tuesday, March 20, 2012 6:54 AM To: [log in to unmask] Subject: Re: Related objects Hi Amber, At The National Gallery, London we use a generic relationship for all our parent – child groupings e.g. panels of altarpieces, decorative schemes, series and pairs of paintings etc This is how the relationship is entered Relationship = ‘group-group member’ Relation1 = group Relation1 Plural = groups Relation1 Prepositional = is part of: Relation1 Plural prepositional = is part of: Relation2 = group member Relation2 Plural = group members Relation2 Prepositional = comprises: Relation2 Plural prepositional = comprises: Description = Use to link groups of related works e.g. parts of an altarpiece. Link the virtual parent record (GROUP numbered) to related child records (L or NG numbered) When we copy TMS data to our web site we change the language to display the relationship to the public, see http://www.nationalgallery.org.uk/paintings/william-hogarth-marriage-a-la-mode-1-the-marriage-settlement Best wishes, Gillian Gillian Essam Collection Information Manager The National Gallery Trafalgar Square London WC2N 5DN T +44 (0)20 7747 2543 F +44 (0)20 7747 2472 E [log in to unmask]<mailto:[log in to unmask]> www.nationalgallery.org.uk<http://www.nationalgallery.org.uk/> ________________________________ From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Morgan, Amber Sent: 19 March 2012 17:26 To: [log in to unmask] Subject: Re: Related objects That makes sense. However, this same Parent-Child relationship structure has been used for non-TC items. The easiest solution, I think, would be to change the relationship terms to something universal so I don’t have to pick back through all of the records to separate out parent-child records that aren’t TCs. There’s probably a way to do this through some SQL magic, but I don’t have that kind of access to the back end. ________________________________ From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Moxley, Jeri Sent: Monday, March 19, 2012 12:18 PM To: [log in to unmask] Subject: Re: Related objects How about Parent = 'Time Capsule' & Child = 'Part of Time Capsule'? Jeri Moxley Manager, Collection and Exhibition Technologies The Museum of Modern Art 11 West 53 Street, New York, NY 10019-5497 Tel. (212) 708-9599 Fax. (212) 333-1102 On Mon, Mar 19, 2012 at 12:06 PM, Morgan, Amber <[log in to unmask]<mailto:[log in to unmask]>> wrote: I think there is something weird going on with the way our related objects work in TMS. It’s a system that I inherited, so I don’t want to go making some major change to it until I’m sure that it’s incorrect and not just a matter of me misunderstanding how it works. This is going to be really tricky to explain in an email, but I’ll give it a shot… We want to create parent-child relationships between the records for our Time Capsules and all of the items inside. The TC would be the parent, the contents would be child records. When I go to the relationships tab for the parent object, I select “add child,” and my option for the type of relationship is “IsPartOf.” I can then add all of the related child records, no problem. When I go to the child records, I can see the relationship for the parent record – it says “HasPart,” and lists the parent record. What I think is kind of weird is the relationship names. When I’m in a child record, I see this: Objects • HasPart o TC23, Andy Warhol, Time Capsules: Time Capsule 23 But I think that reads like “This object has a part, and it is TC23,” when what I’m really trying to say is that “This object has a parent, and it is TC23,” or, “This object is a part of TC23.” But maybe you’re supposed to read it from the bottom up? The functionality of all of this seems to work fine, it’s just the language of the relationship that seems odd to me. Here’s a screenshot of how the relationship is set up. [cid:image001.jpg@01CD0687.CD3003C0] What do you guys think? Should I switch “HasPart” and “IsPartOf?” Thanks, Amber the warhol: Amber E. Morgan Associate Registrar 117 Sandusky Street Pittsburgh, PA 15212 T 412.237.8306<tel:412.237.8306> F 412.237.8340<tel:412.237.8340> E [log in to unmask]<mailto:[log in to unmask]> W www.warhol.org<http://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 The information contained in this message and/or attachments is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any system and destroy any copies. Any views expressed in this message are those of the individual sender. 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. ---------------------------------------------------------------- Turner Inspired: In the Light of Claude 14 March - 5 June 2012 Book now: http://www.nationalgallery.org.uk/turner-inspired Sign up for news, offers and exclusive competitions from the National Gallery: http://www.nationalgallery.org.uk/what/news/subscribe.htm 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.