Hi Clare

Thank you for your reply.

I have not had many replies in various forums, so would appreciate if you could you explain a bit more about transactional replication with an "updateable subscription"? Would the Updates for client B be replicated back to the Publisher?

I have also browsed BOL. I thought my answer would be a Trigger NOT FOR REPLICATION however that applies to the actual schema. 🙁

I am sure this is not an "exceptional" scenario as many people have disparate databases that need to sync only a portion of the data between the databases.

Thanks again for your assistance.