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?

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]