I am very new to Zoho Creator. I am trying develop my first application for a small company I work for. My problem is as follows:

I have a one form called Estimator which has 2 fields

      Estimator's name 

      Estimator's Email Id

The second Form is called Estimator's Log where one of the fields is Estimator which is a "Lookup" field and the values are looked up from the Estimator list. I also have an Estimator's Email field in Estimator's log which I want the program to auto update as soon as I select the estimator from the dropdown. 

Please help!

Thank you in advance