Sorry for the dumb question, but how do you create a Secondary Object Number? BTW - Not using TMS 2010 yet. The use of Secondary Object Number may be just the ticket for those that use different numbers to track objects, particulalrly loans (for instance I use a loan # for loans -- eg IL2010.01 -- but Curators also like to use their own #s that usually consists of an acronym for an exhibition and a counting #). Thanks, Noel Noel Valentin Registrar EL MUSEO DEL BARRIO 1230 Fifth Avenue @ 104th Street New York, NY. 10029 Tel: 212 660 7120 Fax: 212 831 7927 Email: [log in to unmask] ----- Original Message ----- From: The Museum System (TMS) Users <[log in to unmask]> To: [log in to unmask] <[log in to unmask]> Sent: Tue Jun 29 14:16:41 2010 Subject: Re: Alternate number search Hi Courtney, If your old number is appearing in red at the top of your Object Record then it has been recorded as a “Secondary Object Number.” Secondary Object Numbers are searchable under the “Secondary Object Number” field in the Objects Table. So if you can go into the DbConfiguration tool and choose to Manage Query Groups => Available Hierarchies, navigate to the Objects Node and at that point you can add “Secondary Object Number” field to your Query Assistant. At that point you should be able to search for your old number by using this field “Secondary Object Number” in the Query Assistant. Thanks! Best Regards, Bob Farrell Bob Farrell | Director of Product Management [log in to unmask] | 646.733.2239 x252 GallerySystems | www.gallerysystems.com From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Garton, Susan Sent: Tuesday, June 29, 2010 1:57 PM To: [log in to unmask] Subject: Re: Alternate number search But if the old number is appearing in red under the new number, it seems that you have somehow made it a Secondary Object Number as opposed to an Alternate Number. ??? Sue Garton Data Administrator Center for Electronic Research and Outreach Services National Portrait Gallery (202) 633-8554 From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Rjedkin Lee, Natalie Sent: Tuesday, June 29, 2010 1:41 PM To: [log in to unmask] Subject: Re: Alternate number search Hi Courtney! You can search “Alternate Numbers” from the Find Object query window. You just have to remember to check the box in front of Alternate Numbers. Natalie Natalie Rjedkin Lee Registrar National Air and Space Museum Smithsonian Institution Independence Avenue at Sixth Street, S.W. MRC 310 PO Box 37012 Washington, DC 20013-7012 Tel: 202.633.2384 Fax: 202.786.2113 From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Christine Droll Sent: Tuesday, June 29, 2010 12:43 PM To: [log in to unmask] Subject: Re: Alternate number search Courtney, is “Alternate Number” a field in your Query Assistant? (or any other customized query you may have made?) Christine Christine Droll Collections Database Administrator The Nelson-Atkins Museum of Art 4525 Oak Street Kansas City, MO 64111-1873 t: 816.751.1333 f: 816.751.0499 From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Courtney Wagner Sent: Tuesday, June 29, 2010 11:06 AM To: [log in to unmask] Subject: Alternate number search Hello fellow users, I'm unable to search 'alternate numbers' in my database. Specifically: A 'promised gift' in the collection is made a permanent piece so we've given it a new object number and have kept the old number as it's 'secondary number' (the box in the object number window is checked to use this as an alternate number). The old number now appears in red under the new number in my data view window but I am unable to use the old number when performing a search. Has this happened to anyone else? Any suggestions? Thanks! Courtney Wagner Manager of Photo Services American Folk Art Museum 49 East 52nd Street, 6th Floor New York, NY 10022 Tel. 212.977.7170, Ext. 331 Fax. 212.977.8134