Writing to a field
I have a 2 table that contain employee data and a 2nd that calculates their salary every month.
Salary calculation data comes from another table that contains thier actual worked days and commissons.
When I calculate thier salary I want to write the date of the current salary payment to the employee data table.
Last month the Employee_salary date = December 31, 2008
Calculated salaries for January 2009
Update the Employee_salary date = January 31,2009
I have made a relationship between the two Employee_salary date <-> Salary Calcultion_Date
It does not seem to update to the next date and will only show the date for December.
Any help is appreciated