Hi Lisa
 
I don't think there is. 
 
However, if you or someone else is able to access the database directly,
the following bit of SQL should work:
 
select distinct 

o.objectnumber

from 

objects o, objcomponents oc, objlocations ol

where 

o.objectid = oc.objectid

and oc.currentobjlocid = ol.objlocationid

and ol.locationid = -1

Jon
Tate
 
 -----Original Message-----
From: The Museum System (TMS) Users [mailto:[log in to unmask]]
On Behalf Of Gaunt, Lisa
Sent: 05 March 2007 15:36
To: [log in to unmask]
Subject: searching for records with no current location



        Could anyone tell me if there is an easy way to search for
records that have no current location recorded?

         

        Lisa Gaunt

        Documentation Manager

        Bolton Museums, Art Gallery & Aquarium

        Le Mans Crescent

        Bolton BL1 1SE

        01204 332173

         

        www.boltonmuseums.org.uk <http://www.boltonmuseums.org.uk> 



        This e-mail and any attached files are confidential and may also
be legally privileged. They are intended solely for the intended
addressee. If you are not the addressee please e-mail it back to the
sender and then immediately, permanently delete it. Do not read, print,
re-transmit, store or act in reliance on it. This e-mail may be
monitored by Bolton MBC in accordance with current regulations. 
	
        This footnote also confirms that this e-mail message has been
swept for the presence of computer viruses currently known to the
Council. However, the recipient is responsible for virus-checking before
opening this message and any attachment. 
	
        Unless expressly stated to the contrary, any views expressed in
this message are those of the individual sender and may not necessarily
reflect the views of Bolton MBC. 
	
        http://www.bolton.gov.uk