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?
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.