Hello,
I have a situation:

1. Table with parts:
1111
2222
3333
4444

2. Directory with files:
1111.jpg
4444.jpg

I need somehow to link these two, so when I select part, apropriate jpg picture is displayed. Of course since there is spare parts list with 400.000 items and jpg. directory with 5000-6000 pics, I would prefer to do it any other way but manually. Just to mention, both are updated with new items often. Thanks

use the SHELL command and concatenate the field name at the end of the string to open it. such as:on double click

shell("c:\directory\" & me.fieldname & ".jpg")