Hie ,

Have 2 forms :-
In form 1 fields                            In form 2 fields
ID                                                ID (lookup from form 1)
first quantity                              quantity
second quantity                        option(dropdown) first , second , third
third quantity


Needed when Fill form 2
ID = 1
quantity = 50
option = first

create new record in Form 1 report like                  And in form 2 report
ID = 1                                                                                ID = 1
first quantity = 50                                                           quantity = 50
second quantity = 0                                                       first quantity = 50
third quantity = 0                                                            second quantity = 0
                                                                                         third quantity = 0


if again employee choose same ID like:-Fill form 2
ID = 1
quantity = 40
option = second

than update form 1 Report                                          And in form 2 report
ID = 1                                                                                    ID = 1
first quantity = 50                                                               quantity = 90
second quantity = 40                                                         first quantity = 50
third quantity = 0                                                                second quantity = 40
                                                                                             third quantity = 0
(delete the old record)                                                       (delete the old record)

 
Again employee choose same ID like:-Fill form 2
ID = 1
quantity = 60
option = third

than update form 1 Report                                             And in form 2 report
ID = 1                                                                                    ID = 1
first quantity = 50                                                               quantity = 150 
second quantity = 40                                                         first quantity = 50
third quantity = 60                                                              second quantity = 40
                                                                                             third quantity = 60
(delete the old record)                                                      (delete the old record)

How can i achieve this ? please help . Thank you in Advance.