I am trying to create a relationship that will display all my sales files that have not been shipped.

Setup:

• Table Occurences:
  "Sales" - source table is sales
  "Sales_Open" - source table is sales
  
  
• Relationship:
  "Sales_Open" - self join relation, relates back to the same "Sales" file. This relation is link between two fields the 'shipped_n' and 'constant'.
  
  
  
• Fields:
  'constant' - global number field that only contains the number 1.
  'shipped_n' - number field that can be 0 or 1. ) for not shipped and 1 for shipped.
  

I want a portal on a layout, based at the "Sales" table occurrence, to show all the sales that are not shipped.

Problem:

Every time I create this portal I either get nothing or all the records in the sales table displayed.How do I get the right ones to be listed.

I have double checked the individual records in the "Sales" table to see that the fields are filled in with the correct data.

I thought I a needed to get this to work was to relate fields 'constant' <> 'shipped_n', so that it would display all records in "Sales" that have 'shipped_n' = 0 .

I would guess your relationship is going "the wrong way".

In FM7, a relationship based on a global acts like a filter when joining from: global -> indexed, it is ignored (all records) when you go the other way: indexed -> global.