Christine, There is a TitleID field in the table ExhObjXrefs (or you can use the view vgsrpExhObjXrefs...) which connects to the ObjTitle table. ~Chad


On Fri, Feb 21, 2014 at 12:46 PM, Christine Droll <[log in to unmask]> wrote:

Dear all,

 

I am constructing a Crystal Report for a checklist of objects in an exhibition.

 

Working in the Exhibitions module, I want the title to pull from the Exhibitions Objects screen.  On that screen I have changed the title of the object (so that it is different from the title in the Object record).  How do I make it so that the report pulls that title (in Exhibitions module) and not from the title in the Object module?

 

Thanks for your attention,

Christine

 

Christine Droll

Collections Database Administrator

The Nelson-Atkins Museum of Art

4525 Oak Street

Kansas City, MO  64111-1873

T: 816-751-1333

F: 816-751-0499

[log in to unmask]

 

 

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.