AnsweredAssumed Answered


Question asked by Thicks on Dec 30, 2008
Latest reply on Jan 5, 2009 by TSGal




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