Hi Lisa
I think there is a way but you have to do
something in configuration menu to prevent the field value from being a
dropdown.
GS helped me with this. I think you
go to manage table/columns in configuration, select objects, then locations and
right click. Then untick ‘display as distinct list in queries’
under attributes in the edit column box (see below). I did this a long
time ago, so maybe check with GS if this is correct before you do it!
That way I can search on field value is
not equal to * for the site.
Thanks
Caroline
Caroline Delahunty
TMS Officer
National Gallery of
tel: 01 632 5525
ü Help save paper - do you really need to print this email ?
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
01204 332173
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