Merge Replication - Filter a table by multiple tables

Hi,

I have a problem regarding the filtering on a merge replication.

I have a complex Customers / Products database.

Each subscriber to the publication belongs to a sales region.

The idea is to have the data filtered down depending on the sales region so
that the sales team only have the necessary data.

My problem is that the Price table requires filtering by 3 other tables.

When I add the three filter clauses in the wizard it creates a view using
UNION statements for each of the filters. This means that all the data in th
e
price table is being returned. I need the view created to use AND statements
so that I only get data matching all 3 criteria.

I'd thought about creating VIEWS to filter the data, but the wizard will not
all you to filter tables by VIEWS.

Can anyone help?