I've created a Performance Review database for our HR department.
It is two tables and two forms. One table/form (Form1) has various fields for categories, and one table/form (Form2) has various fields for performance summaries. The Summaries table/form is for supervisors. So you would complete Form1, and if the person was a supervisor, complete Form2.
The only info that would be the same in both are Name, Employee #, Job Title... and so on.
The tables are related and the name field in Form2 is a lookup field.
NOW, the HR guy wants this. When someone completes all the employee information in Form1, and goes to Form2, that the common fields be automatcially completed with the common information from Form1 once the persons name is selected in the lookup field. For instance. If I've finished completing the information in Form1, then when I select the individual's name in Form2 from the Name field (which is a lookup), Employee#, Job Title...etc, is automatically placed in the appropriate fields.
Any ideas? I hope my explanation was clear.
It is two tables and two forms. One table/form (Form1) has various fields for categories, and one table/form (Form2) has various fields for performance summaries. The Summaries table/form is for supervisors. So you would complete Form1, and if the person was a supervisor, complete Form2.
The only info that would be the same in both are Name, Employee #, Job Title... and so on.
The tables are related and the name field in Form2 is a lookup field.
NOW, the HR guy wants this. When someone completes all the employee information in Form1, and goes to Form2, that the common fields be automatcially completed with the common information from Form1 once the persons name is selected in the lookup field. For instance. If I've finished completing the information in Form1, then when I select the individual's name in Form2 from the Name field (which is a lookup), Employee#, Job Title...etc, is automatically placed in the appropriate fields.
Any ideas? I hope my explanation was clear.
