I really cant give specific details on how to create the recordset without knowing what tables you want to include in the recordset and how the relation between them is created.
This is why I forwarded a link to the W3Schools page that deals with SQL Joins.
Here are the basic keys to creating a join query:
1) What is the parent table
2) What is the name of the primary key column in the parent table
3) What is the child table
4) What column in the child table creates the foreign key relationship to the primary key column of the parent table.
using that info you can create the join syntax:
SELECT parentTable.*, childTable.*
FROM parentTable
INNER JOIN childTable
ON parentTable.primaryKeyColumn = childTable.foreignKeyColumn
In your recordset you will be replacing the basic query:
SELECT * FROM petdata
with the join query and leaving the WHERE clause untouched.