If you tie a loan to an exhibition you can not only indicate the individual
venues that a particular work is allowed to go to when lending a bunch of
stuff to various venues, but you also capture the exhibition history for the
work in your database.

Suzanne
Whitney

-----Original Message-----
From: Patricia Raynor [mailto:[log in to unmask]]
Sent: Friday, April 11, 2003 12:11 PM
To: [log in to unmask]
Subject: Re: loans module


This is a problem that I have been trying to solve unsuccessfuly.  With our
old database we could track loan objects individually by end date.  We have
many loans where multiple objects have separate loan ending dates (we borrow
and lend a lot of paper artificats for shorter periods of time)

We do not create a new loan for a single object.  I also use the loan
reserve status field to indicate whether it is still on loan or has
returned.  However, I have not been able to satisfactorily come up with a
solution for tracking single objects by loan end/return date.

I'd also like to hear how others track single loan objects.

Patricia  A. Raynor
Museum Specialist
National Postal Museum
Smithsonian Institution
Washington, DC 20560-0570
202-633-9376
202-786-2767 (fax)

Temporary mailing address:
National Postal Museum
Smithsonian Institution
2 Massachusetts Avenue, NE
Post Office Box 75039
Washington, DC 20002

>>> [log in to unmask] 04/11/03 11:47AM >>>
The following is a question from NPG's Registrar's office:
Can anyone share with me how you track single objects within a loan of
multiple objects when that single object returns from loan earlier than the
rest of the objects?  Is a new loan created for that single object or do you
track the status of each object individually on the objects card in "Loan
reserve/status"?  For reporting purposes I need to be able to track the
exact dates each object has been out on loan.