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