i have two tables in a database- attached sample-
1st table is (Table A)tbl2- ( data is automatically imported in)
2nd table is (Table B)tblCopy-( numbers are scanned in later)
the numbers should match- but since tbl2 numbers are being keyed in- some serial#'s are not right-( missing numbers and letters).
i have a form to display the unmatched serial numbers in each table.
Is there anyway I can have serial numbers in tblCopy-overwrite the serial numbers in tbl2 ?
or somehow speed up process - rather than manually correct each serial number?