Thanks for the help and advice over this subject. I have since found that what I was wanting to should really be done through replication
Ive test that and have it working on my test environments, moving this onto the live environement I have come accross an issue which I am about to raise
Thanks again