Hmmmm. I just added "Secondary Object Number" to the query assistant, but still unable to pull the records...

"The Museum System (TMS) Users" <[log in to unmask]> writes:
>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
>



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