I have what I think is a fairly simple idea but can't seem to find the solution.
we have a table1 filled with idnumber, name, address info.
we have a 2nd table that's empty.
data entry person should open up form, type in an idnumber (that will match up to the idnumber on table1) and it will...