Access Data Retrieval

[Kariot]

When relating tables, I want each column to be automatically pulled in the row. For example, if one table has 'name' and 'surname' while another table has 'age,' how can I automatically pull the 'surname' of a row when I retrieve the 'name' from the search wizard in the 'age' table? Can you help me with this?