Hi Gary,

Just an advice: try to avoid using the Filter tab of the View Designer to define relations between tables. For that, use the Join tab, and leave it WHERE clauses to apply conditions. It will structure your views.

Good luck!

Ricardo