Using A Recordset To Call Another Record Set

i have this query string and goes off and pulls off all records from the inktest fields where stock level is below min. But i also want to pull off the make of ink from another table tblmake.

the problem i have is that tbl make is not linked to inktest it goes though another table tblmodel as there is only one make ie Canon many models of printers and each model can have anything upto 4 inks, is there a way i can have another record set something like select * from tblmake or i could create a query that pulls off the ink model and make but only displays the ink and make then select * from newquery where inktestid = newquery.inktestid that should give me what i want kinda rite?? Code: