How to add script to look for pictures based on a field entry
I am a new user of FM Pro. My question is how to add a field that will look for a picture based on the data entered in another field.
Example: in one field the product ID will be entered, such as Bluebird23 ; the objective is to have another field that will display a picture that has been named Bluebird23.jpg. The database is about 2,000 entries with the same number of corresponding pictures in a specific folder.
Could this be done? Any help will be much appreciated!
Mac OS X 10.6.7