Hi,
I'd like to know of a good way to synchronise data that will be changed on a website, with the local office maximiser db. eg, clients will update their contact details on the web, and it has to filter through to the office on maximizer if possible. What would be the best way to do this?

I was thinking of trying to update both databases simultaneously to keep the data in sync, though I'm not sure what the easiest way is to update the maximizer db remotely.

The more difficult question would be what happens when somebody changes the contact details in maximizer, then how would one get the changes to reflect on the website... I suppose synchronizing two db's with changes from both sides isn't really doable? What would your suggestions be?

Thanks!!