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

    Writing to a field

    Musashi

      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