Multiple Linked Photos In Report

[pjd218]

I store the path to photos for individual records in my database.

Each record can have unlimited photos. All works well in displaying the photos on the form using a subform.

When printing a report, I would like to be able to use multiple photos. However, the link is stored in an unbound text field. Each photo does have its own ID that corresponds to the parent record.

So if I wanted two different photos on the report, how would I call each path into the appropriate field on the form?

 

[PWise]

What is your table structure ?

 

[pjd218]

ProjectPhotoTBL linked to ProjectDetailTBL via ProjectID which is the primary for ProjectDetailTBL.

ProjectPhotoTBL has 3 fields:

ProjectPhotoID (autonumber)
ProjectID (pick up from parent form)
PhotoLink (which is a hyperlink field)

The ProjectphotoID is updated by a search button on the Photo subform that allows me to search for the file and save the path.