Need help with auto population

[the_swiss]

i have a table with lots of rows and and many columns pertaining to the primary key. I also have a blank table with the same headings. I want to be able to type in a primary key from table 1, and have the full row in table 2 filled out with the relevant data.
this is for a school project so a quick reply would be very much appreciated.
Thanks

Column A is a list of unique names. The rest of the columns are attributes of the primary key in column A. (Location, Age, Gender etc.)
i want to link the attributes to the primary key, so that when i type a unique name in the blank table, the relevant data from the source table gets automatically input in the correct cells.