Skip to main content
Question

Display first image from child table record

  • April 5, 2017
  • 0 replies
  • 46 views
I have a child table of photos which are URL's pointing to Photos on an external Database.
I can see them when I add them to the Parent Form and all is good. 

The URL is changed to show the image by using a formula text field.
"<img src=" &[Photo URL] & 
">"

However, I want to extract Only the first photo related to each record to use in the Parent Report to show a thumbnail of the first photo.

I have the Minimum Photo Record ID# in the parent table and it shows the link to the record but I dont know how to proceed now to get it to:

A: Show the Image
B: Resize it (i guess I could resize it in the child table and link to that field?)

Any ideas?
      This topic has been closed for replies.

      I assumed that you have already formula text field on the child table which shows the picture on the child record right?

      Are you able to see all the thumbnails on the parent report? if yes then you can create a summary field (i.e minimum - record id or first photo record id#) then, create a custom report in your child table and make a filter that record ID# is equal to (minimum - record id or first photo record id#).

      Now, use that custom report in the form element setting in your parent form.

      Please let me know if you need further clarification although I haven't tested this solution.

      Thanks,
      Gaurav
      If you summarize the minimum record ID of the children, you can then do a reverse relationship to float up the [Photo URL] field to the Parent. Make a relationship where 1 child has Many parents based in that summary record ID field.

      As for the width, this should work

      "
      My solution will create an actual field on the Parent
      Terms & ConditionsAccessibility statement