Skip to Content
0

Data Table Linking

May 23, 2017 at 11:01 PM

28

avatar image

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?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Dell Stinnett-Christy May 24, 2017 at 02:36 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Jeff Stiegler May 24, 2017 at 09:02 PM
0

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.


links.png (38.7 kB)
linkoptions.png (14.1 kB)
Share
10 |10000 characters needed characters left characters exceeded