you need to edit the recordset so that it uses a join query to return related data from both tables.
you don't go into to much detail on how the relationship of the 2 tables is created, so i can give an example of the query, but you can find more details on join queries here:
sql_join.asp