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.