Access 2010

I have 3 tables and 1 form based on one of the tables.

I want to select a first name, surname and classname from a second table and display and store the data in my main form and table.

Is there any simple way to use a lookup (or similar) on the second table and select the data. Using the Lookup Wizard I can see the data but only store one of the fields.

The form should be based on the query that "joins" all the data together rather than the table, so construct a query that contains all the data you want to display, then create the form from that.

Thanks TKenny15.

I assumed that a query was used for querying the database to produce a report.
Will read up and try and figure the query option out.