1. Form 1 = Planning, Field - Job NO I Plan QTY I Actual output
01 I 300000 I * (5000+7500)
2. Form 2 = Daily output performance
Field - Job No I Date I Actual QTY
01 I 12/9/2014 I 5000
01 I 13/9/2014 I 7500
How do I update automatically to 'form 1- actual output' , when I key-in the data to 'form 2'