Image linking

[Jast]

Hello, I have my database working ok. But, now I have received image files (jpg files) and I want to import them into the database.

I would like to link them, not store them in the db, as they are 15,000 files.

The import pictures function get all the files unsorted. Is there any way of modifying the databse so record=1 gets file=1.jpg, record=2 gets file=2.jpg, and so on? (even if the file is missing, I would still like the reference to the file to be created).

Thank you.

[Genx]

This script should do it for you if i correctly understand what you want.

Go To Record[First]

Loop

...SetField[ ImagePath ; "image:/C:/Folders/More Folders/Image Folder/" & Get(RecordNumber) & ".jpg"]

...Go To Record[ Next ; Exit After Last ]

End Loop