Jump to content

Relation help


This topic is 7225 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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 .

Link to comment
Share on other sites

This topic is 7225 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.