Master detail report

[Lydia]

I am trying to figure out how to show all rows from a master table even if
the detail table does not have records for some rows.

 

[Dennis]

Lydia,

You left out quite a bit of detail, but I'm guessing that you are trying to
build either a query or report from a master and detail table. When you join
the two tables, you want do a Left Join where you include all records from
the master table and only those records from the detail table where the
joined fields are equal".

You need to build a query and join the two tables. The SQL should look like:

SELECT tblClass.ClassNo, tblLookUpD.LongDesc
FROM tblClass LEFT JOIN tblLookUpD ON tblClass.ClassName = tblLookUpD.CodeKey;


Good luck,


Dennis

 

[Duane Hookom]

This is basically a query question. Use a LEFT or RIGHT JOIN that includes
all the records from the Master table.