Form question

[gfbrummer]

I have a table with info already entered. It is information pertaining to individual employees (badge #, name, etc). I would love to be able to go to a form and enter the badge number and it populate the rest of the info in this table. From there I would like to enter additional info on the form and save it to another table. Is this possible? I have limited experience in access and can only describe it as similar to a vlookup in excel. Thanks for any help.

[June7]

Should not be saving Name, etc. in the table, only the foreign key (badge # ?). Major principle of relational database is 'don't duplicate data'. Use queries to join tables so that data from related records can be displayed.

BTW, advise not to use spaces, special characters, punctuation (underscore is exception) in names. Better would be BadgeNum or Badge_Num.