AnsweredAssumed Answered

Outer joins help

Question asked by ErikToh on Dec 9, 2012
Latest reply on Dec 11, 2012 by philmodjunk


Outer joins help


     Just completed the FileMaker Training Series Module 3, and the last exercise involves setting up two portals. On the left is the product order history, and on the right is a portal containing the products that other customers within the same tier have ordered.

     I would like the second portal to show the products that other customers in the same tier have ordered that the current customer has yet to order i.e. an outer join. I played with the relationships graph with a ≠ and it didn't seem to work. I also tried filtering the portal records based on a calculation so that the product IDs from both tables do not match, and it didn't work either.