Skip to main content
Question

Child report on parent record to show photos

I have a parent table "Projects" with a child table of "Supporting Documents"
When viewing a project record I have a table for the child showing all linked supporting documents
Allot of the supporting documents are photos and I would like to have a thumbnail view in this table instead of IMG_****.jpg
FYI: [Document File] is where the attachment is.


------------------------------
Russell Beaubien
------------------------------
This topic has been closed for replies.

Forum|alt.badge.img+14
courtesy of Mark Shnier, see below. If you need more help definitely go to him. He consults for me and does an amazing job. Create a formular rich text field with below. Be sure to replace the 15 in both spots (by e15) with your Document File field ID.





 var text URL = URLRoot() & "up/" & Dbid() & "/a/r" & [Record ID#] & "/e15/v0/ target=_blank" & "DummydateTime=" & ToText(Now()) & URLEncode(ToText([Document File]));  // that last part is to defeat browser cacheing

var text words = "<img src="  & URLRoot() & "up/" & Dbid() & "/a/r" & [Record ID#] & "/e15/v0/" &  "\" width=\"100\"" & "DummydateTime=" & ToText(Now()) & URLEncode(ToText([Document File])) &">";

"<a href=" & $URL & ">" & $Words & "</a>"


// you can set EITHER the width or the height, but do not set both or the image will get skewed.


------------------------------
Mike Tamoush
------------------------------
Terms & ConditionsAccessibility statement