Update existing with newly added autonumber field

[ecristen]

I added an autonumber field to the Account entity so I can store an accountnumber. I allready have approx 750 existing Account records. How can I populate all existing records with a value for this autonumber field?

Regards, Emil

[tanya]

Hi,
I think it's possible with database UPDATE only

[ecristen]

Hi tanya, thanks for your response. I was allready assuming this would be the only option to do the update, even though I hoped that a batch update of the field or using Workflow could do the trick too.

Kind Regards,