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

 

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.