W
Whits End
I have a database that has sample measurements for urchin sizes. We manually
input all values into one table for each validation ID. For each validation
ID there may be several tote# and also lots of measurement values for each
tote. These are written down manually on sampling sheets in the plant. Once
the initial input is put into the database we then do a verification of the
first input by typing in the same values in the same order into another
table. We then manually run a query to compare the two tables for
discrepancies.
What I would like to happen is that when inputting the values for
verification the second time, a message would come up immediately to inform
of any discrepancy in the tote# and in the measurement value for each line of
input. Also at the same time the program would give the option to keep the
value that is correct. If the first value typed in at the initial input
stage is incorrect but the verification value typed in is correct, I want the
option to replace the first table with the correct value. At the end of the
verification input for each validation ID I need all the values in the
verification table to be cleared so that the next validation ID values can be
verified with the same process. HELP.....
input all values into one table for each validation ID. For each validation
ID there may be several tote# and also lots of measurement values for each
tote. These are written down manually on sampling sheets in the plant. Once
the initial input is put into the database we then do a verification of the
first input by typing in the same values in the same order into another
table. We then manually run a query to compare the two tables for
discrepancies.
What I would like to happen is that when inputting the values for
verification the second time, a message would come up immediately to inform
of any discrepancy in the tote# and in the measurement value for each line of
input. Also at the same time the program would give the option to keep the
value that is correct. If the first value typed in at the initial input
stage is incorrect but the verification value typed in is correct, I want the
option to replace the first table with the correct value. At the end of the
verification input for each validation ID I need all the values in the
verification table to be cleared so that the next validation ID values can be
verified with the same process. HELP.....