+ Start a Discussion

Cross Object Field Values

I need to populate a custom field on an opportunity with a customfield value that exists on the user record of the Opportunity owner.  i have created an formula field that pulls the value from the "user" but it is the opportunity Creator and it only happens when the opportunity is created.  I need the field to be populated real-time for existing opportunities of the current opportunity owner.  I can't just load the information because it would affect Last Modified reporting.  Any ideas.