Update field based on selection of lookup from another field

Update field based on selection of lookup from another field

Hi,

I am new at Zoho, and I am starting a new database.  Right now I have 2 forms: Client and Call Log.

The Client form stores all contact info: name, company, address, phone numbers, etc.

The Call Log form will track all phone calls, emails and meetings with our contacts stored in the Client form.

I have created the relationship between the two forms using a the Client Name field.

Now what I want to do is have the Company Name field on the Call Log update automatically based on the selection of the Client Name field within the Call Log.

I assume a script is needed here to run when the Client Name field is updated.  Any suggestions greatly appreciated.

Thanks!

John