Skip to Content

Data Table Linking

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    May 24, 2017 at 02:36 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • May 24, 2017 at 09:02 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded