Hello,
I have next problem. I need to make replication data from one table to another when new data appears in one of them.
I have 3 same database on diffrent locations. If "customerinfo" appears in one database - it must be replicated to rest 2

I try to make something like replication server. Separate database where 3 local view (one for each table) db1_view_customers , db2_view_cutomers, db3_viewcustomers...

Problem is.. when I open first view... rest use same database as first one! and not possible to update right table.

With remote view - its open correct table.. but not possible to update, because store procedre in database not supportable by odbc!

Need idea!
Thanks
Denis