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

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.