You can do this with an Automation, but I suggest that you make a copy of the app first to test the Automation unless you are very confident with Automation.
You should be able to trigger an Automation when the Status is changed to Approved, and filter the records to be updated where the Record ID# is NOT equal to the Record ID of the Trigger record Record ID and the Document # equals the Document # of the trigger record.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.commark.shnier@gmail.com
------------------------------
