Save pdf using field values as file name

[DebBerg]

I would like to save a record as a .pdf file and name the file using a combination of 3 field values.

I have the script working to save the .pdf and a variable set to name the file ($filename). It work except how the file name appears.

the information I'm trying to combine is:

last name (smith)

start date (7-1-12)

project name (med)

I set the variable calculation to :

Employeefunding::employeelastname & "_" & Employeefunding::modstartdate & "_" & grantspeedtype1::ProjectName & ".pdf"

which gives me a file name of _7-1-12_

I want it to say Smith_7-1-12_med

What am I doing wrong?

[bcooney]

What is the relationship from Employeefunding to grantspeedtype? You're in the context of employeefunding, apparently, and you need a relationship to get a value from the other table, grantspeedtype.

[DebBerg]

Yes. There is a relationship to grantspeedtype1 but I can't even pull up the employee last name.

[bcooney]

Can you post the file? zip it first.