Discussions

Expand all | Collapse all

How do I show an image from one table in another table?

  • 1.  How do I show an image from one table in another table?

    Posted 06-22-2018 00:50
    I have a relationship and it shares multiple things but I need the image from one to appear in the other table.


  • 2.  RE: How do I show an image from one table in another table?

    Posted 06-22-2018 01:30
    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.


  • 3.  RE: How do I show an image from one table in another table?

    Posted 07-16-2018 06:00
    how do i look it up to the child


  • 4.  RE: How do I show an image from one table in another table?

    Posted 07-16-2018 11:58
    Build the formula on the Parent Table which holds the image. Then just make a lookup field in your relationship.


  • 5.  RE: How do I show an image from one table in another table?

    Posted 10-11-2018 15:55
    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



  • 6.  RE: How do I show an image from one table in another table?

    Posted 10-11-2018 16:11
    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.


  • 7.  RE: How do I show an image from one table in another table?

    Posted 10-11-2018 16:20
    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
    ">https://d2r1vs3d9006ap.cloudfront.net/s3_images/1756233/RackMultipart20181011-80587-s8f2su-Screen_Shot_2018-10-11_at_12.17.45_PM_inline.png?1539274718">

    in the original table, I added the field (Display picture) into the form but is not working as well.


  • 8.  RE: How do I show an image from one table in another table?

    Posted 10-11-2018 16:31
    What is the field called which is the [Record ID#] of the Table.  Is it still called [Record ID#] or did you rename it?

    I was expecting the formula to read as 

    "<img src=" & URLRoot() & "up/" & Dbid () & "/a/r" 
    & [Record ID#] & "/e200/v0>" 


  • 9.  RE: How do I show an image from one table in another table?

    Posted 10-11-2018 16:45
    Yes, I rename it. there is one field in the original table name TNSID but that is not the Key field. I changed for the Key field and worked perfectly. you help me to find the error thank you so much