Hi, I am new to FM and I am trying to set up a new database solution to hold details of products I sell.
I have images of each of the products and I have created a container field in the products table in the database.
I know I can drag and drop the images into the relevant container fields for each product but I have 100's of products and I am looking for a way I can bulk update the relevant products with the product image from a folder on my Mac. I can match the product images to the relevant product records using the value of a text field I already have stored in the database i.e. value of field = xxx image file for that product = xxx.jpg
I was hoping I could do the updates with an import but I cant find a way of importing images to container fields.
Maybe I need a script to do this?
Can anyone point me in the right direction?
Thanks in advance