AnsweredAssumed Answered

Question about related field

Question asked by leonhart1981_1 on Jul 31, 2015
Latest reply on Aug 1, 2015 by leonhart1981_1

Title

Question about related field

Post

I have a database with three tables: employee detail, offer package, payroll

Employee detail table contains detailed information about each employees; offer package table contains offering letter for each employee; payroll table is the table that I use to calculate employee's payroll for each period

**Relationship diagram are attached. 

Now, I am at payroll table try to calculate my employees' payroll, and there is a related filed called "base salary" that I borrowed from offer package table. For some reasons, I need to change the value in the "base salary" field for payroll table, but I want to keep the field's value in offer package table unchanged. Am I able to do that? Please help~~~

 

Relationship_3.png

Outcomes