This was used in 9.35, but I expect it will still work. UPDATE Objects SET CreditLine = 'Your New Credit Line' WHERE ObjectID IN (select ObjectID FROM ObjPkgList OPL INNER JOIN ObjectPackages OP ON OPL.ObjectPackageID = OP.ObjectPackageID WHERE OP.Name = 'Object Package Name') Dick Richard Grant Executive Director The Richard Diebenkorn Foundation 3214 College Avenue Berkeley, CA 94705 510-428-1400 510-459-4556 (mobile) From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Sara Patrello Sent: Tuesday, February 24, 2015 8:46 AM To: [log in to unmask] Subject: Batch Updating Credit Lines Hello All, Has anyone successfully batch-updated object credit lines in TMS on records that were previously made? If so, could you let me know what your process was? Thank you! Sara - Sara Patrello Assistant Registrar Smart Museum of Art The University of Chicago 5550 S. Greenwood Avenue Chicago, IL 60637 <mailto:[log in to unmask]> [log in to unmask] 773.702.9549 <http://smartmuseum.uchicago.edu/> smartmuseum.uchicago.edu <http://smartmuseum.uchicago.edu/> Celebrating 40 years in 2014-2015 To unsubscribe, send an email to [log in to unmask] <mailto:[log in to unmask]> with the following commands in the body of the email: signoff TMSUSERS // eoj You will receive a confirmation that your subscription has been removed. To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email: signoff TMSUSERS // eoj You will receive a confirmation that your subscription has been removed.