Table filtering one to many relationship

[cklo338]

Hi team,

I ran into a strange issue and would like to get some advice. 

I have two tables, the first one called Issue, which looks like this

Issue No.	Title
ID-001	aaa
ID-002	bbb
ID-003	ccc

The second one Comment which like this

Issue No.	Comment
ID-002	Comment line 1
ID-002	Comment line 2
ID-003	Comment line 3

It is a one-to-many relationship and two tables are linked using Issue No.

I want to have table (the visulization object) that shows all issue#, titile and comment. 

The strange thing is that in the visualization, if I added the comment field, the table automatically filtered down to the issues that have comment. In this case, the ID-001 will not show...

I attached my relationship and table object setup here.

Any advice is welcome. Thank you!

[CoreyP]

You need to change the filtering direction from both to single so that the issues tables filters the comments table.