Join the Tables
You need to join the two tables. In advanced view edit the query to join the tables, it would be something like this, where X is your ProdRangeID value:
SELECT *
FROM products INNER JOIN prodrange ON products.ProdRangeID = prodrange.ProdRangeID
WHERE prodrange.ProdRangeID = X
HTH.