Relationship filtering on many to one doesnt filter

[duggy]

Hi,

I have several tables all linked to each other. What I am finding is that the filtering from many to one doesnt respond. If I filter on the one to many side then the many table information changes. However if I filter on the reverse from the many side then the one table is not impacted (using bi-directional filtering).

A user is assigned to multiple sites. The users table contain the user information and the multiplesites table is the table that contains the userid and the siteid that user is assigned to:

So user 123 can be assinged to site 1, 2, 5 and 6 for example.

When I filter on the sites table then the multiplesites table filters and so does the daily table.  But when I filter on the daily or on the multiplesites table the filtering doenst activate. I.e. when I filter on the many to one direction (initially the daily to sites was also bi-directional) it doesnt filter the one site, just the many side of the relationship.

Any ideas?

Much appreciated.