here's what i have.
[Employee]table <-(table for employee data)
Employee
PERNR ID
Entity
Department
[Training_Log] <-(table to track data for training hours)
Entity
Department
PERNR
Employee
Activity
Completion Date
Hours
In a nut shell, ideally what i want to be able to do is on the form for [Training_log] i want to be able to select the employee name from a drop down, and the releveant employee data to pop into place without having to re-type it all. So if anyone has any ideas on how to help me do this that would be great.
thanks!
[Employee]table <-(table for employee data)
Employee
PERNR ID
Entity
Department
[Training_Log] <-(table to track data for training hours)
Entity
Department
PERNR
Employee
Activity
Completion Date
Hours
In a nut shell, ideally what i want to be able to do is on the form for [Training_log] i want to be able to select the employee name from a drop down, and the releveant employee data to pop into place without having to re-type it all. So if anyone has any ideas on how to help me do this that would be great.
thanks!