Subject: | |
From: | |
Reply To: | The Museum System (TMS) Users |
Date: | Mon, 5 Mar 2007 17:22:48 -0000 |
Content-Type: | multipart/related |
Parts/Attachments: |
|
|
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 Ireland
Merrion Square West
Dublin 2
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
Bolton Museums, Art Gallery & Aquarium
Le Mans Crescent
Bolton BL1 1SE
01204 332173
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
***********************************************************************************
Exhibitions at the National Gallery of Ireland,
http://www.nationalgallery.ie/html/exhibitions.html
***********************************************************************************
The information contained in this email and in any attachments is confidential and is intended solely for the use and attention of the intended recipient(s). This information may be subject to legal & professional privilege.
If you are not an intended recipient of this email, you must not use, disclose, copy, distribute or retain this message or any part of it. If you have received this email in error, please notify the sender immediately and delete all copies of this email from your computer system(s).
This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.
The National Gallery of Ireland
Merrion Square West
Dublin 2
Ireland
Tel: 353-1-661 5133
Fax: 353-1-661 5372
http://www.nationalgallery.ie
**********************************************************************************
|
|
|