Show image in portal if field has any value

[Robert17]

Seems simple enough, however I'm stuck on this one for some reason. Here's the deal...

I have a field called notes_attachment which allows a file to be attached to a note entry in a notes portal. On the portal view I want to have a file icon if there is a file (any value) in the notes_attachment field. I have the file icon in a seperate table as a global field (where all my images are stored). Now, how would I setup a realtionship so that the field only appears on the portal if there is a value in the notes_attachment field?

Thanks!

[-Queue-]

Have you tried using a calculated container field in the notes table like Case( not IsEmpty(notes_attachment); globalfileicon ) and displaying this field in the parent's portal?

[Robert17]

THANKS! That did it. I kept trying with a realtionship. Never done/seen a calculation on a container. Learn something new everyday!