AnsweredAssumed Answered

Filtering an unrelated table

Question asked by GwRodriguez on Jul 14, 2015
Latest reply on Jul 16, 2015 by GwRodriguez

Title

Filtering an unrelated table

Post

Here's the cartesian relationship in question:

Shows>----<Mixers2

What I would like to do is have a portal in Shows that displays all records of the table Mixers.  This part is simple, I created a second table occurrence (Mixers2), and made a cartesian relationship.  The portal shows all the records no problem.  

The tricky part is I now want to filter it dynamically.  I tried creating a new field in Shows called gShowFilter and adding to the cartesian relationship gShowsFilter=Manufacture.  But the filter doesn't work, meaning that the portal becomes empty.

Thoughts?

Outcomes