I'm sorry for not making my problem clear to you.
What I meant was this,I want double entries to be done for the questionairre forms.there will be two data entry clerks. one will do the first entry of forms and another will do the second entry of the same forms.so that means there will be two tables,one for the first entry and the other would be for the second entry.
so how would i compare the values of these two tables and find differences of values of respective fields and make corrections to them in the master table.for instance,if a field is 'sex' and the value in the physical form is male but the first entry value is female and the second entry value is male ie typing error,hence the code i would write to pick up this difference is the problem that i am trying to solve.
Hope I made myself clear with this post.
Thankyou very much in advance for your time.
What I meant was this,I want double entries to be done for the questionairre forms.there will be two data entry clerks. one will do the first entry of forms and another will do the second entry of the same forms.so that means there will be two tables,one for the first entry and the other would be for the second entry.
so how would i compare the values of these two tables and find differences of values of respective fields and make corrections to them in the master table.for instance,if a field is 'sex' and the value in the physical form is male but the first entry value is female and the second entry value is male ie typing error,hence the code i would write to pick up this difference is the problem that i am trying to solve.
Hope I made myself clear with this post.
Thankyou very much in advance for your time.