Would love to see a copy of it too. Cornelius Marr J Whitley Smith Consulting > > >> From: Richard Grant <[log in to unmask]> >> Date: July 21, 2009 6:07:39 PM CDT >> To: [log in to unmask] >> Subject: Re: adding a constituent >> Reply-To: "The Museum System (TMS) Users" <[log in to unmask] >> > >> > >> 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:TMSUSERS@SI- >> LISTSERV.SI.EDU] 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