Storing image paths in table projectphotos. Multiple images for each project. No problem displaying via subform on main project form. Each image path has auto number id and is linked to project number.
Need to be able to display 2 of x pictures on a report based on the main project table.
As it stands now, I get two copies of the report showing the two separate images eventhough I have 2 image holders on the report in the detail section. The images display fine. If I have 3 images, I get 3 iterations of the report.
Report is based on a query linking the projet detail table to the projectphotos table via the project id.
Access 2007. Should I just go ahead and store the images in the DB? That way I can have photo1, photo2, etc....? Not preferred because some projects have 40+ photos.
The query references the project id and photolink.
Need something like photolink1 and photolink2 as fields on the report or somehow iterate thru all of the photo links and display x number of photos on a report.
Hopes this makes sense...a bit late.
As always, any help is appreciated.
Need to be able to display 2 of x pictures on a report based on the main project table.
As it stands now, I get two copies of the report showing the two separate images eventhough I have 2 image holders on the report in the detail section. The images display fine. If I have 3 images, I get 3 iterations of the report.
Report is based on a query linking the projet detail table to the projectphotos table via the project id.
Access 2007. Should I just go ahead and store the images in the DB? That way I can have photo1, photo2, etc....? Not preferred because some projects have 40+ photos.
The query references the project id and photolink.
Need something like photolink1 and photolink2 as fields on the report or somehow iterate thru all of the photo links and display x number of photos on a report.
Hopes this makes sense...a bit late.
As always, any help is appreciated.
