Help on forms

[wongray]

Hello,

Need help. I'm planning to create a database that would capture picture into the database and able to preview it in the form.

Could you please advise what is the best way to do it?

My Idea will be:

Product a - then it will display JPG files 1.jpg and 2.jpg
Product c - display 3.jpg...

Thanks

 

[Rabbie]

Firstly I would not store the .jpg files in the database as this will lead to rapid bloat. Instead store the .jpg files in a separate folder and just store a link to the images in your DB.

You will then be able to display the image on a form when you need it.

 

[wongray]

Hi Rabbie, Thanks for the suggestion.

I agree with you on store the .jpg files into the database..

I should have explain a bit more details.

What I want to is I have to create a database that specific a product ID and each product will have a picture display when the product ID is selected.

Also, I'm not how to create a form that would allow me to point the UNC path of the photos.

Please advice.

Regards

Firstly I would not store the .jpg files in the database as this will lead to rapid bloat. Instead store the .jpg files in a separate folder and just store a link to the images in your DB.

You will then be able to display the image on a form when you need it.