AnsweredAssumed Answered

Writing to a field

Question asked by Musashi on Jan 18, 2009
Latest reply on Jan 20, 2009 by TSGal


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.


For example:


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