If your relationship is:
Shot Records::Shot Number = Editorial Records::Shot Number
Then you can use either a calculation field in Shot Records or conditional formatting on the Shot Records layout to flag the current record if the values aren't the same.
And example would be to use conditional formatting to change the fill color of the Shot Records::Comp Total Frames if it's value does not match the value of the correspoding field in Editorial Records:
Self ≠ Editorial Records::Comp Total Frames
The same can be set up for Cut Total Frames.
Aside from the question asked....why is the data being stored twice on two different tables?
Why not just store it once on one table?
Is there a benefit to having the ability for two tables to disagree?