Display first image from child table record
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 ...
Forum Discussion
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
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
- I assumed that you have already formula text field on the child table which shows the picture on the child record right? - Yes, this is the [Property Image] field which uses "<img src=" &[Photo URL] &
">"
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#). - I already have the Minimum Photo Record ID# summary
I created the child Report.
Then created a Report Link and selected that report on my form.
Bingo! Thanks Guarav. - ah, that was only half the battle. I want to show it the the Parent Report and when I add that Report Link field, it just shows me a link with the Min Photo Record ID number on it ??
