AnsweredAssumed Answered

Relationships????

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

Title

Relationships????

Post

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

 

Problem

When I place an employee# in one field it places it into all fields in each catagory 

 

    

Outcomes