Question about related field
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~~~