Or the other option is... import the pictures into another table in file maker and then have a relationship setup however, is it possible on the import...filemaker can get the picture name and import the name into a field called File Name. Then setup a relationship between both tables.
Client Profile Table = CaseNumber C12345
and Client Image Table File Name field =C12345
then insert Picture into
Client Profile Table= Image Field
Something like that. Is this possible . I dont know how else to make the link on the relationship.
Import Records | Folder can import all the images in a folder into a table of images. There's an option where you can specify that the file name be imported into a second field in the same table--which can be linked in a relationship to your existing table.
Hmm, "profile". These wouldn't be bottle profiles would they? Used to work in the bottle closure industry and these terms and the format to the SKU (C12345) look very familiar.