I have a form (Students_form) to add students information.

Let's say that Students_form has two fields:

1) Student ID (automatically generated by Zoho Creator)

2) CostPerHour which is a currency field

I have created another form called Invoice_form.

Let's say that Invoice_form has again two fields:

1) Student ID (which is a Lookup field from Student_form)

2) CostPerHour wich is again a currency field

What I would like to do is the following:

When I select the student ID from the dropdown list in the Invoice_form, I would like the CostPerHour field (in the invoice_form) to be filled automatically with the relevant data from the Students_form (actually the CostPerHour that maches the Student ID.

Note: I know how to do that with a dynamic picklist (like the example https://help.creator.zoho.com/Dynamically-adding-items-to-a-picklist.html), but this is not what I want.