Hi Clare

I have have been running into error after error from the start. I have managed to get around them and am hitting my head against the wall of "linked servers". It seems to be related to security and not SQL security from what I can see? Unfortunately I am running out of time for this project and will have to revert to merge without filtering, not that that is ideal for the client, however we have to move on.

I will get stuck into it again to get to the bottom of it when I have some more time (if that ever happens :))

What I did want ask, which is something I read after following your suggestions, is that if the subscriber had to create a new client (ex. Client J) other that the filtered Client B, client J would be replicated to the Publisher. So in essence the filter applies one way from the publisher to the subscriber but not the other way? Is that statement correct?

Thank you again for taking the time to assist. I do really appreciate that.

Regards

Deon