Testing Secondary Form Access

Row 1

Row 2

When using Tabs, I will frequently create multiple views of the same underlying data. This seems to be a problem with GF/GV. This page demonstrates the problem using two views:

  • Issues --> Assigned Person
  • Person --> Issue Assigned to that person

The results of this test surprised me. The Issue --> Assigned person returned an INNER JOIN, while the Person --> Issue returned an OUTER JOIN. The difference is described in THIS ARTICLE. The question now arises, how do I construct my code to force what I want (INNER vs. OUTER) join?

Powered by ConneXions Builder