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.