Data Table Linking

[SuperCoder]

Creating a report with two tables, A and B, which are linked by a common field name. I want all of the entries in table A to print on the report whether or not there is a corresponding entry in table B.

When I run the report, only 8 (out of 11) of the entries in A show on the report while 3 do not. These 3 have no entries in table B.

What do I need to do to have all of the entries in A show on the report?

[DellSC · Accepted solution]

Link FROM Table A to Table B. Right-click on the link and go to Link Options. Make the link a "Left Outer" join.

-Dell

[SuperCoder]

I tried you solution but the result was the same - only 8 or 11 entries showed from table A, which is noted below as FosterParent.