I am trying to get have a field after data is entered perform a lookup value from a related table to fill in 2 other fields
I have a layout that has 4 catagories designed: Complainant, Witness, Respondent and Complaining Witness.
Each catagory has the same same fields setup for 3 repetitions: Employee#, First Name, Last Name....Example of fields ResFirstName, ResEmployee#, ComEmployee#
I have another layout that has: Employee's ID#, First Name Last Name stored. I have set the relationships so that its employee# field is related to my 4 other employee# fields in the original layout. I have made all of the FirstName, LastName fields a lookup
When I place an employee# in one field it places it into all fields in each catagory