is there anyway to make a text box autofill in the rest of a name if it has previously been entered in one table and save it into another table??


also from this would it be possible to make it bring up all other fields that are filled in for that previous record and save it as a new record.