Jarred, Are you looking for a SQL query to pull this together, or a Crystal Report? Either way, I'm happy to help. We have existing reports that I can share with you once I'm back later this week. Ian On Tue, Nov 13, 2018 at 2:34 PM Jarred Wilson <[log in to unmask]> wrote: > Hi all, > > > > I’m trying to find an easy way for my marketing colleagues to pull > information about both the image and the object when using something from > the collection in publication. > > > > From the media record > > Public Caption [MediaMaster.PublicCaption] > > Copyright [MediaMaster.Copyright] > > Restrictions [MediaMaster.Restrictions] > > > > From the object record > > tombstone info > > *and* > > Copyright [ObjRights.Copyright] > > Credit Line [ObjRights.CreditLineRepro] > > Restrictions [ObjRights.Restrictions] > > > > Has anyone got a report which does something like this? Thanks in advance! > > > > Jarred > > > > Jarred Wilson > > Associate Registrar > > > > The John and Mable Ringling Museum of Art > > 5401 Bay Shore Road > > Sarasota, FL 34243 > > > > tel. 941-359-5700 x1504 > > fax 941-359-7716 > > www.ringling.org > > > > [image: TheRingling_iconsTOP_fsu] > > > 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. > -- *Ian Eckert* Associate Director, Collection & Exhibition Information (CEI) *The Museum of Modern Art* 11 West 53rd Street New York, NY 10019 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.