Hi Aaron! Have you made sure that the link between your Objects table and
your MediaXRefs table is an Outer Join and not an Inner Join? If it's
inner, you won't see any record that doesn't have a media record.

Fatima

-- 


*Fatima Mahdi*Collections Information Specialist/TMS


*Virginia Museum of Fine Arts*200 N. Boulevard
Richmond, VA 23220-4007
T 804.340.1443

[log in to unmask]



[image: image.png]

On Tue, Jan 15, 2019 at 3:09 PM Aaron Zalonis <[log in to unmask]>
wrote:

> Hi, all,
> I've managed to create a Crystal Report that goes haywire if an image is
> not present in the Object Record it's being run against. It acts like the
> object doesn't exist, instead of presenting all the information (title,
> medium, dimensions, etc.) that does exist in the object record (and just
> not including a blank image). There are potentially many points of failure
> with this, but I'm wondering if anyone has ever run up against this kind of
> thing. If so, where did the problem exist for you?
> I'm really stumped on this one. The same thing (failure) happens in both
> TMS 2016 and TMS 2018.
> Best,
> Aaron
>
> AARON ZALONIS
> ASSISTANT REGISTRAR / DATABASE MANAGER
>
> NASHER MUSEUM OF ART AT DUKE UNIVERSITY
> box 90732  durham nc 27708-0732
> t +1 919 684 1971
> e [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.
>


-- 


*Fatima Mahdi*Collections Information Specialist/TMS


*Virginia Museum of Fine Arts *200 N. Boulevard
Richmond, VA 23220-4007
T 804.340.1443

[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.