Listing Products with photos beside

[pahmed]

Hi everyone
I need to display each product records with its photo in forms and reports
For example in a table view form under the Picture column showing every records picture line by line

Thanks

[UnklDonald418]

It is usually best to store all the images in a single sub-directory, and include a text field in your database table to hold the path/filename for the image file.
Include an image control on the form using the path/filename field as the data source.
Using the form, select a product record and right click on the image control and select Insert graphics from.
Navigate to and select the desired image and the path/filename will be inserted in the database for the selected product record..

For a discussion of the options for displaying images on a database form see
[Tutorial] Pictures in Base
to include images on a report you will probably need the Oracle Report Builder extension.
https://extensions.openoffice.org/en/pr ... rt-builder

[lsemmens]

One issue not mentioned in the first reply reply in the tutorial is that there is a 2Gb limit on the size of tables with embedded pictures in any 32 bit OS. It is always worthwhile linking to said pictures or you can run up against cryptic error messages that bear no resemblance to the actual problem. I spent months working that out back in my early days with Access (version 2.0). I, eventually, found reference to it buried deep in their online documentation.