Hello Wayne,

We had a similar problem when a gift of a group of objects to a foundation
required changing ex-collection constituents from current owner to previous
owner and then adding a new current owner. Dimitry kindly helped us cook up
a SQL query to accomplish this for all objects in a particular object
package. Maybe he can help you out. Let me know if you want a copy of ours. 
  
Richard Grant 
The Richard Diebenkorn Catalogue Raisonné
3200 College Avenue #2 
Berkeley, CA 94705 
510-428-1400 
510-459-4556 (mobile) 
[log in to unmask] 



-----Original Message-----
From: The Museum System (TMS) Users [mailto:[log in to unmask]] On
Behalf Of Wayne Phillips
Sent: Tuesday, July 21, 2009 2:38 PM
To: [log in to unmask]
Subject: adding a constituent

This may be a very easy thing to do, but since I'm a curator and not a
database administrator or IT person, I figured I should ask those who know
more than I.

Is there an easy way to add a constituent (donor) to a group of records all
at once instead of adding the constituent to each record one at a time?
These records are all under the same accession number with different point
numbers.  There are 2 separate donors for this old accession, and I need to
go back and add a second donor name to about 100 records.  Am hoping I don't
have to do it one at a time.  Any help you can offer would be greatly
appreciated!

Wayne Phillips
Curator of Costumes and Textiles
Curator of Carnival Collections
Louisiana State Museum
P. O. Box 2448
New Orleans, LA 70176-2448
(504) 568-2475
(800) 568-6968
http://lsm.crt.state.la.us