Andrea -
A couple of things. First, your 'Current Salary' on the Requests table should have a matching Snapshot field. Essentially, this will capture the value of a field at the time the Parent record is selected. Just create another Numeric/Currency field and name it 'Salary at time of Request' (or something similar) and select the Snapshot option at the bottom, being sure to select 'Current Salary' for the matching Lookup field. This will resolve your issue moving forward, but not for any existing records.
Second, Rather than updating the Salary on the Employee table directly, I would recommend using the Requests table to help calculate the 'Current Salary'. You could have the 'Starting Salary' on the Employee table, which would never change. Then you would want the following:
- Pay Adjustment - Field on the Requests table that would capture any adjustments (up or down) to the Salary
- Total Adjustments - Summary field on the Employee table that summarizes all approved Requests associated to the Employee
- Current Salary - Formula field on the Employee table that calculates as follows: [Starting Salary] + [Total Adjustments]
This way, your total is always immediately updated and accurate.
------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quick Base Solution Provider
Atlanta GA
404.800.1702 /
http://datablender.io/------------------------------
