Attempting to retrieve an account field based on the value of a picklist item in an opportunity.
All opportunities are linked to a contact, all contacts are linked to accounts.
Is there a way when someone creates a new opportunity and selects the appropriate value in a picklist to have either an onchange () script or other means retrieve the appropriate account field from the related account entity and populate a custom text field in the opportunity with that value?
Any help would be greatly appreciated.