+ Start a Discussion

Help with SQL Update of multiple fields

We're trying to automate territory assignment via a zip code table.

The zip codes and assignments have been uploaded as a custom object.
What I need to do is have Salesforce query the zip table whenever a zip code is entered for an address and return the associated sales rep name, city, state and county from the table and populate those fields in the address.

Can someone guide me on how best to accomplish this?
This would be a good use of an scontrol. It would require that you provide a link on the page to the scontrol passing the record id and the zip code to the scontrol. The scontrol could then lookup the correct info from the custom table using the ajax toolkit and upon finding a match, update the record and return the user to the record.