I've created a field that my users will populate as part of our Opportunity workflow. When the Opportunity has been succesfully closed, I would like to transfer the data from that one field to a field of the same name in the Company table. Any suggestions on how I could do that?

i.e.,
Transfer oppo_IDNum to comp_IDNum when the "Opportunity Obtained" button is clicked in the workflow.

Is this a job for a table level script? Can this be run via the workflow itself?

Any help would be appreciated.

Thanks!

 This can be run via a TLS or as a sql command as part of the Opportunity workflow. 

What exactly are you trying ot accomplish? 

Since our sales staff only deals with the Opportunity Workflow, I'm trying to take information they enter and add it to the appropriate field(s) on the Company Table.  Basically, I'm trying to use the Opportunity workflow to have our sales staff fill in gaps in the Company information.

What would the SQL command look like in the workflow?

Try something like this......

If not send me a message.... 

Update company set comp_xxxxxx = yyyyyy where comp_companyid = #oppo_companyid#

I tried an ExecSQL command in my workflow using the following syntax:

Update company set comp_ssnein = oppo_ssnein where comp_companyid = #oppo_companyid#

However, I get an Invalid Workflow ExecSql error.

Any suggestions on where I went wrong with the syntax?

 I got it figured out now.  I was missing # signs on the oppo_ssnein field.  Also, my system uses oppo_PrimaryCompanyID as the link between opportunity and client.  Once I got those two things resolved, it worked perfectly.

Thanks for the help!