If you're fixing a problem, say a typo was copied to 100 records, you can use the Search & Replace option: query up the batch you need to fix, go to Maintenance > Database > Search and Replace. If you're needing to overwrite a bunch of different things, or insert missing info, you'd use a SQL update (or ask your IT or database manager to). Let's pretend this is a whole set of photos whose Object Numbers are something like *PhotographsABC.1, PhotographsABC.2, PhotographsABC.3 ... PhotographsABC.1000. *Here is what your SQL would look like: Update Objects Set CreditLine = ' *your correct credit info *' where ObjectNumber like 'PhotographsABC.%' On Tue, Feb 24, 2015 at 11:46 AM, LaNore, Ruth, DCA <[log in to unmask] > wrote: > Iād love to know this too! > > > > *Ruth LaNore* > > *Registrar* > > *Museum of International Folk Art* > > P.O. Box 2087 > > Santa Fe, NM 87504 > > 505.476.1218 > > www.moifa.org > > *Subscribe to MOIFA E-News > <http://www.internationalfolkart.org/about/mailing-list.html>* > > > > *From:* The Museum System (TMS) Users [mailto:[log in to unmask]] > *On Behalf Of *Sara Patrello > *Sent:* Tuesday, February 24, 2015 9: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 > > [log in to unmask] > 773.702.9549 > smartmuseum.uchicago.edu > > [image: So Smart. From the Start] <http://smartmuseum.uchicago.edu/> > > *Celebrating 40 years in 2014ā2015* > > 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. > 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. > 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.