We've found using Access to view current locations and mark the inventory status & date in the "Remarks" field to be very useful. This requires the creation of 2-3 queries that work together. It allows you to see everything in table fashion by location and have TMS open at the same time to move things found or in the wrong place. The access query is then updated, and the "found" status of the object can be recorded at the same time. Plus, it records the history of the inventory in place that stays with the location history of the object and is searchable from within TMS - a way of monitoring the progress of the inventory. Assistant Registrar for Collections Information Smithsonian Institution Freer Gallery of Art and Arthur M. Sackler Gallery 1050 Independence Avenue, SW MRC 707, P.O. Box 37012 Washington, DC 20013-7012 tel:202-633-0348 fax:202-633-9770 [log in to unmask] ________________________________ From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Jeri Moxley Sent: Wednesday, January 24, 2007 12:55 PM To: [log in to unmask] Subject: Re: Large Collections Inventories We're in the midst of a collection inventory and are entering the Inventory stamp one record at a time. It would be great if it were possible to enter the inventory stamp in the way that the Random Check feature works for a group of records. Jeri -------------------------------------------------------------------- Jeri Moxley Rojas TMS Specialist Solomon R. Guggenheim Museum 1071 Fifth Avenue New York, NY 10128 tel: (212) 423-3509 fax: (212) 462-4225 email: [log in to unmask] <mailto:[log in to unmask]> ________________________________ From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Finkel, Susan Sent: Wednesday, January 24, 2007 11:05 AM To: [log in to unmask] Subject: Large Collections Inventories TMS ListServ Members: How do you handle the posting of inventory location verifications for a large number of objects? It is my understanding that current TMS inventory functionality deals with these verifications one object at a time. Is there an approach anyone has used successfully when the inventory involves thousands of objects? Thanks! Sue Finkel Collections Information Systems Coordinator Registrar's Office National Gallery of Art Washington, DC Americans in Paris 1860 - 1900 22 February - 21 May 2006 Book Now http://www.nationalgallery.org.uk/exhibitions/americans_paris/default.ht m Open until 9pm every Wednesday with live music & bar Sign up for the latest news, offers and exclusive competitions from the National Gallery by clicking on this link http://www.nationalgallery.org.uk/what/news/subscribe.htm