Make Table from Folder

Question

I have hundreds of jpeg items in a folder on my pc. Fortunately, they have been named in number (from 1 to 3000) according to the primary ID of my parent table. The idea was to simply match a jpeg name with the ID on the parent table.
How can I create a child table that matches the jpeg name with the parent table? I want to avoid the laborious work of dropping each jpeg item into its corresponding place using forms.

Answer 1

I'm confused. You do NOT need to make a table of the image files, I explained this in my first response. You have a table of students, correct? In that Student table is the student ID, correct? That Student ID corresponds to the name of the image file, correct?

If that is the case you do NOT need a separate table to store the locations of the image files. You can use the expression shown to generate the location for the individual student.

Also, you say these images are stored on your hard drive in your users folder. Unless you are the sole user of this app, then the images should be stored on a server folder.

Answer 2

Glad to assist.