Default a value in Query

[ecugrad]

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......

 

[mdthornton]

Depends how you are doing the insert.... is it from a form, SQL, directly in the datasheet view etc etc Best Regards,
Mike