Images in Forms/Reports

[coynesj]

Hi guys,

Having an ongoing problem at the moment.

I have created a form for one table. It contains a combo box linked to another table. This second table has a primary key that is the name of an image and another field which contains the file path to that image. The combo box shows the primary key, and I have used a basic lookup to populate a text field in the form with the corresponding link. I can then produce the image using the image control and a single line of code.

That's all well and good, but not what I actually want. I need the image to be displayed a report based on this form. When I create the report there is no option to copy the image over and I can't take the data from the lookup for the very reason that it is a lookup and therefore won't save in my original table.

Can anyone give me some suggestions please on how to actually do this.

Any help would be much appreciated and I can give more information if it's required.

Thanks.

 

[Simon_MT]

When you say

"I have created a form for one table. It contains a combo box linked to another table".

What do you actually mean. The easier way to handle Images is that they relate to a unique reference or ID.

If a reference like StockID has a value of 1 then the corresponding image relating to the StockID should be 1 also eg. 1.jpg. StockID = 2 then the Image File = 2.jpg etc.

If you add a stock record then your image represents the same entitity.

Simon

 

[coynesj]

Thanks for getting back to me...

When I say that I created a form from the table, I mean that after creating a table, I generated a form with all the elements of that table in it.

I then created a relationship between that table and another containing images. These images are stored on my server rather than the database so that it doesn't fill up too quickly. Therefore I use the link my virtue of a lookup... However I can't get the lookup to follow through to the report....

 

[Simon_MT]

You can avoid storing the images if you think about it?

Simon

 

[coynesj]

Sorry, you're confusing me a bit... I am not storing the images in the database, they are in a completely seperate folder on my server.... The only connection to them is their file path that IS stored in the database...

I just need to know how to pull this link into my report as I can't get a lookup to work from the form to the report.... I can only get the lookup working within the form, but due to rules of databaseing, I can't store that as a text field to pull through to the report...