How to load a relate field into another field

Hi Everyone,

We currently have a relate field and would like to have the value selected in this field appear in another field on the same module. To my knowledge, it is not possible via studio and a calculated field. Has anyone had any luck loading a relate field to another field? Please note this is not a relationship field either.

Fields:
1. Relate field to users module from opportunities
2. Text field on opportunities module.

Sugar version 10.0.2

Thanks!