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