Is there a way to auto populate fields in tables based on the criteria of other fields.
For example, I have a list of employees and when I select the employee ID from a lookup table, is there a way to get all the other employee information in the other fields to auto populate.
For instance when I select the employee ID, I want the employment date, years of service and salary of auto populate.
Thank you
For example, I have a list of employees and when I select the employee ID from a lookup table, is there a way to get all the other employee information in the other fields to auto populate.
For instance when I select the employee ID, I want the employment date, years of service and salary of auto populate.
Thank you