Auto-populating field data once a option is made

Auto-populating field data once a option is made

Hi,

How would I auto-populate fields in a form that relate to a different form? For example, I have a form in which I want to choose a specific category, and the price to auto-populate (note that "category name" field relates to a different field. Within the related field, I would have the category name and price. Essentially, I want the main form to fetch data from a related field within a different form. Note the category name is a lookup field.

I'd like to do the same for Employee Name and employee email (I'd like the employee email auto-populated within the main form based on the Employee name (i.e. fetching data from a different form based on the Employee name). Also note that both the employee name and employee email are lookup fields.

Thanks!