Set Default Value to field from Reference

[jenn123]

Is there a way to set the default value to a dot walked field of a reference field on the same table? See example below on the Change Order table. Would like to set the "Requested for" default value to be the business contact which comes from the Project itself (referenced in Project Number). Is there any way to do this?

[Brad Tilton · Accepted solution]

Hmm...If it's not working this way I would try it in a before insert business rule instead.

current.u_requested_for = current.u_project.u_business_contact;

[jenn123]

That worked - thanks very much!