Filtering an unrelated table
Here's the cartesian relationship in question:
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.