AnsweredAssumed Answered

Self-Join relationship confusion

Question asked by DeanneRene on Sep 22, 2009
Latest reply on Sep 22, 2009 by DeanneRene


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.