Help with a workflows

I’m kind of thinking I can’t do this with a workflow and have to do a before save hook.

Basically Accounts have a “customer service rep” (not the assigned user) a relate field to users.

What I want to run a workflow on save from the Opp to go and look for the related customer service rep to the Account (that is related to the Opp) and update the Opp with the customer service rep.

I don’t think I can accomplish this with workflow because I can get the related account, but I can’t get the related Account->Customer Service Rep.

Maybe I’m just not seeing it. Does anyone have any Ideas? if not I’ll have write a hook.

Hi Paul,

yes, that seems to be the case.
Via the standard workflows, it seems to be impossible to retrieve the 2nd level relationship.