First, let me say the experst on this site are the best........
I have two tables "tblEmployees and "tblResults", the employees tables holds current salary dollars and results holds incentive points, etc. My relationship is a one(Employees) to many (Results)using EmployeeID as the key. For each new record input in the Results table I want to pull the current salary dollars from the employees table to populate the salary field in the result table. I do incentive calculations per month and roll them up each quarter and need to hold the historical salary dollar amount for that month in the result table.
How do I default the salary data in the Employees.salary field to the salary data in the Results.salary field for each record entered.
Thanks......
I have two tables "tblEmployees and "tblResults", the employees tables holds current salary dollars and results holds incentive points, etc. My relationship is a one(Employees) to many (Results)using EmployeeID as the key. For each new record input in the Results table I want to pull the current salary dollars from the employees table to populate the salary field in the result table. I do incentive calculations per month and roll them up each quarter and need to hold the historical salary dollar amount for that month in the result table.
How do I default the salary data in the Employees.salary field to the salary data in the Results.salary field for each record entered.
Thanks......
