Query based on multiple tables

[tripp4640]

I'm trying to create a query based on two tables. The first table,
tblProdMaster is a list of products with a primary key (IDmaster) and fields
that describe the product (e.g., unit price). The second table, tblPsheet,
has a primary key (IDqty) and a foreign key (IDmaster) from the first table.
The second table, tblPsheet, includes fields such as LineItemNo and
LineItemQty. Ive set up the relationship between the tables
(tblProdMaster=one; tblQsheet=many). I've created a query and the two tables
and the relationship betwee them shows up in design view. I edited the
relationship and chose option 3, to display all records from tblQsheet (right
table) and only those records from tblProdMaster (left table) that match.
After adding the fields from both tables that I want to display and run the
query, the selected fields from tblProdMaster (left table) are not displayed
in Datasheet view.

What am I doing wrong?

 

[Larry Daugherty]

I think that you actually want all of the records from tblProdMaster

HTH

 

[tripp4640]

Not quite, tblProductMaster includes all information associated with a
product. For this query, I only want to include fields related to product
pricing (material cost, installation cost and the like).