MichaelTamoush
5 years agoQrew Captain
Re: Child report on parent record to show photos
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.
------------------------------
Mike Tamoush
------------------------------
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
------------------------------