I’m new to Base, using Ubuntu 16. In Access, I entered “=C:\path”&[picture] into the image field. picture is the name of the field containing a .jpg filename for each record. Then each time I clicked “next record” in the form, I’d get the related picture. How can I do this in Base? Browsing for each of the 1800 records isn’t workable.
Yes, I figured it out. On main page go to Tools, sql. Enter a generic path name into a varchar field and execute. My generic path name is UPDATE “INV” SET “PathToPicture” = LEFT(“BestPicture”, 2) + CHAR(47) + “BestPicture”
Then in the form, rightclick on the content box for “PathToPicture”, and click “replace with”, click “image control.”
Now the picture changes with each record, as long as I keep the pictures in the right folders.