New to Calculations and Scripts, HELP
I have created to separate tables one called employees and the other Data Entry. In the employees table I have 3 fields: Employee ID, First Name, Last Name. On the Data Entry I have 3 fields: Employee ID, Respondents First Name, Respondents Last Name. I have the two tables related by the Employee ID field.
What I am trying to accomplish is that when an Employee ID is entered on the Data Entry Table it will look to see if that Employee exist on my Employees Table and automatically fill in the Respondents First Name and Respondents Last Name fields from the First Name Last Name fields on the Employee table. I would also like if the employee ID entered on the Data Entry table did not exist that it would take the new information and store it to the Employees Table.
I think that I need both tables and I need to write a calculation for this, I tried an IF, but I think I also need a script, but I could be way off. Please Help