Forum Discussion
DarkCoolCat
Aug 25, 2022Copper Contributor
Display pictures on a form from multiple tables?
I have multiple tables with item names and a picture for them what i want on a Single form.
I created my main Form from my master table, I can add item names in a text box on this Form from various tables using the ID and =DLookup in the control source but i cant figure out how to do it with a picture.
I can add pictures from the Recorded source table with no problem, but other tables has me stumped, i can add a sub form to do it but i do not like the look of it. Everything is linked in relationships because all the text boxes i have in the form using =DLookup from other tables work.
- arnel_gpSteel Contributoruse Query instead of Dlookup.
on the query you join your table to your master table (on common field that you use to dlookup).
then include in the output column the image field from the master table.