I'm trying to setup a form that looks like a folder stucture. There are pictures on the form that will be programmed as buttons. When the user clicks on the picture/button, I want filemaker to open up a folder on the shared drive. The only tricky part is that the folder that is opened will depend on a value that is in a field.
each record is for a project number (ProjectID), depending on the project number will determine which folder to open.
for projectID001 the folder will be
for projectID002 the folder will be
so basically I need a variable so that the folder name is dynamic with whatever record the user is on
I've tried this:
Created the button and set the button to open a hyperlink
Specified the value of the hyper link to be: "File://N:/" + PexData::ProjectID but it just returns a value of 1.
Any help would be appreciated to make it so I can add this feature to my DB!