AnsweredAssumed Answered

Writing to a field

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

Title

Writing to a field

Post

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

 

 

Outcomes