Why won't this work?

[UpNorth]

Set Field[_work_order::t_technician; Account::At_User_Name]

When creating a new record I have this script step and it doesn't put anything in the t_technician field. I want it so when creating a new record it takes the user name form the account table and put it into the technician field in the work order table. Any ideas?

[mr_vodka]

You need to temporarily store the data into a variable prior to the new record being created. Otherwise when you create a new record, there is no related information since the new record is empty.

[UpNorth]

I hear ya. Thank you.