Fetch and update

Fetch and update

Would like to select data in a look up field and have it populate data in another field in the same form.

Example

Select an individuals name via look up in form2 and have it fetch the data from pay rate in form1 and populate pay rate in form2.