3 Replies Latest reply on Jan 20, 2009 7:44 AM by TSGal

    Writing to a field



      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