I have a database with 2 tables.
One table is an equipment inventory and the second table is an employee table.
The employee table has a list of all of the employees in the business.
In the inventory table, among all of the fields, there are three fields that correspond to the employee table:
What I would like to do is have the FIRST NAME and LAST NAME automatically populate with the correct info once the AD USERNAME is entered.
Is there a way to do so?