You are close. You need to concatenate the fields to the applescript text string…
"set target of Finder window 1 to folder \"" & Residential Customers::Last Name & " - " & Residential Customers::Customers ID & "\" of …
There are a few ways to simplify these applescripts:
• Use the List(line 1; line 2; …) function. This removes the need for '& ¶ &' at the end of each line.
• Use Quote() function to place quotes around field values. This removes the need to escape quotes \"
• Use the applescript 'the quoted form of …'. This removes the need to escape quotes \"
Awesome! Works great. Thank you very much. Fred