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.