How do I show an image from one table in another table?
I have a relationship and it shares multiple things but I need the image from one to appear in the other table.
Forum Discussion
8 Replies
- No problem
Make a formula rich text field lie this on the table with the image."<img src=" & URLRoot() & "up/" & Dbid () & "/a/r" & [Record ID#] & "/e324/v0 height=100>"
and then look it up to the child. Replace the 324 with the field ID of the file attachment image.
Set either the height or the width to your liking. (change height to width to control the width. If you try to set both the image will get skewed. - how do i look it up to the child
- Build the formula on the Parent Table which holds the image. Then just make a lookup field in your relationship.
- Hi. I followed more than one time all your guidance but still not showing the image in the child table. this is the outcome with I lookup in the child table
thanks in advance - Does the link work on the original table before the lookup?
Did you set the correct field ID which holds the file attachment?
Can you post your formula. - formula in original table: "<img src=" & URLRoot() & "up/" & Dbid () & "/a/r"
& [TNSID] & "/e200/v0>"
see the picture bellow how both fiels has been set on the original table
in the original table, I added the field (Display picture) into the form but is not working as well.
