Is there a way to reference an externally stored image in reports?
I know you can have an image field and a form and browse to upload images one by one but that is very tedious for thousands of stock lines - I’d like it to dynamically look for [stock_code].jpg in a networked folder.
Is this possible?
Use a text field to store a URL that points to your images.
Use an on click action macro to open the hyperlink which will automatically start up whatever the default application you have to open your images.
You are correct that you can sore images directly BUT if your have 1000’s of images your database will be LARGE and is likely to run slowly.
HTH