Open (windows xp) folder by Field name

[ryolitex]

Hi I am VERY new to FileMaker Pro 11, (never used it before this week!) I looked for the answer to the question I am about to ask, but cannot seem to find it. Ít is very simple I am sure.. anyway sorry if this is a stupid or redundant question but I am very fusterated, anyway here it is:

I simply wish to use the open url to open a folder with the same name as the field called: Name_Last

I created a button that will open (on windows) any folder (c:\records) for example.. and I have sub folders by last name of people. I would like to use the button to open C:\records\Jones or C:\records\Smith etc.. where Smith or Jones is the name in the Last Name field (Name_Last) field of any given record.

I can use open url and simply put in c:\records.. but I thought if I put in c:\records\ & Name_Last it would work.. but it does not.. I know I am pretty stupid when it comes to this stuff. So you can laugh at me but please wont some one help! : Thanks in advance from an Ultra Novice.

[dansmith65]

You are on the right track. You can do what you are wanting. You may be having a problem with the backslash being an escape character. To troubleshoot this, try un-checking the 'Perform without dialog' option on the Open URL step so that you can see what URL the script is trying to open.

Also, here is the calculation you would need to enter to concatenate two strings: (notice the extra backslash)

"C:\Windows\\" & "System32"