We use the Constituent Module to separate the collections by using Owner as the description for which collection it represents, which is attached to each object in the objects module.  Also, our accession number is different for each collection, either with a prefix or different numbering systems.  In the loan module, we use a Text Entry to indicate which collection the loan is from, thereby keeping all our loans in sequential order for report purposes.  It is very simple to query on a text entry if you want stats for each collection.   All of our exhibitions are related to a loan, so you can tell by the text entry in the loan module or the accession numbers in the object listing.  The collections I am using TMS for are fine art collections that have been acquired for two different foundations and special purchase projects for the Government of Alberta, ie, Portrait Collection, Jubilee Collection, etc.    
 
Betty Rothwell
Art Collections Registrar
Alberta Community Development   

-----Original Message-----
From: The Museum System (TMS) Users [mailto:[log in to unmask]]On Behalf Of Amy Noel
Sent: Tuesday, September 21, 2004 11:13 AM
To: [log in to unmask]
Subject: Sharing a TMS database between different collections in the same Institution


Hi all, 
 
Wondering if some of you have some experience, insight in sharing a TMS database for different collections within the same institution. 
 
We are beginning to add GRI Special Collections into our TMS and are starting to work out procedures on how to share loan and exhibition records.  I am interested in any experience or insight you all might have on this issue. 
 
Thanks, 
Amy Noel 
The J. Paul Getty Museum