AnsweredAssumed Answered

Filter a single base table via a parent-child relationship

Question asked by rohrkemper on Jun 23, 2016
Latest reply on Jun 23, 2016 by Mike_Mitchell

Attached, you'll find a demo database which is as simple as possible while still illustrating my issue. (FM 11)


There are 6 records in "table". On the graph, you'll see 4 TOs based on this single base table.


Via a child-parent relationship, I'm expecting to see 2 of the 6 records each in the tables called "EN", "CN", and "JP".


I do see the expected 2 records in each of these tables, but I additionally see 4 records which are blank.


  • Why are the blank records present?
  • How can I correct this while having only a single base table?


If anyone has success with this, could you please upload the database again here? Our production environment is currently FM 11, but I also have FM 14 and 15 installed for testing.


Screen Shot 2016-06-23 at 10.52.44.png


Layout based on TO: table  (all 6 records)

Screen Shot 2016-06-23 at 10.51.43.png


Layout based on TO: EN  (still 6 records with 4 blanks, expected only 2 records)

Screen Shot 2016-06-23 at 10.51.56.png




Screen Shot 2016-06-23 at 10.55.07.png