I have a student database. Each student has a unique student Id.

 

I have a drive full of student pictures - each picture is named <student_id>.jpg.

 

I have created a container field which stores the container data externally.

 

Is there any way I can dump the student pictures into the relevant folder determined by the container field, and automatically update the container field so that it looks for the equivalent <student_id>.jpg.

 

eg UPDATE tblStudents SET PHOTO = 'Databases/Students/Photos/<Student_id>.jpg.

 

Many thanks

 

Phillip

I did it like this : 

 

Setup a calculation field.  Let it result in a container and add this text "image:/Databases/Students/Photos/" & <Student_id> & ".jpg"

 

You probably need to add the full file path, including volume name.

 

Cheers