2 Replies Latest reply on Sep 22, 2009 1:39 PM by DeanneRene

    Self-Join relationship confusion



      Self-Join relationship confusion



      I have an unexpected result from a self join relationship.  The relationship is from a global field gStatus to a field Status.  I have a layout with the global field and a portal based on the self join.  The idea is that when the global is changed the contents of the portal will show all the records of the current table that match the contents of the global.  The result is that it is showing me all the records regardless of the contents of the match fields.


      If I use the same scheme with another table, thus not a self-join, then it behaves as expected.


      I am at a loss as to why.