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.