TMSUSERS Archives

The Museum System (TMS) Users

TMSUSERS@SI-LISTSERV.SI.EDU
Options: Use Monospaced Font
Show HTML Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
Begin Date for Renewals of Long Term Loans
From:
Susan Garton <[log in to unmask]>
Reply To:
The Museum System (TMS) Users
Date:
Fri, 5 Sep 2003 09:21:02 -0400
Content-Type:
multipart/alternative
Parts/Attachments:
text/plain (834 bytes) , text/html (1410 bytes) 
When dealing with renewals of long term loans, how are others recording the Begin Date of the renewal period? We would like that date to be searchable and reportable, but we do not want to create an entirely new loan for each renewal period. Nor do we want to change the Begin Date each time--we would like that to remain the initial Begin Date. We use Display Date for a different purpose, and that is the only other date field available. We are considering putting renewal dates in a remarks field in the Statuses grid, but a text field is definitely not ideal. Has this been an issue for anyone else out there?
 
Thanks for any advice you can offer.
 
Susan Foster Garton
Data Administrator
Center for Electronic Research and Outreach Services
National Portrait Gallery
Tel:  (202) 275-1842
Fax:  (202) 275-1907
[log in to unmask]

ATOM RSS1 RSS2