automation to create customer

julkifli33

hi all
i have several database
can we create automation when we create customer in database 1
then it will create also in database 2,database 3, etc....
how to do it?
thanks

mohana_cse06

You can do it with stored procedure which can be called from navision when you insert a record and insert in other databases..

julkifli33

mohana_cse06 wrote:

You can do it with stored procedure which can be called from navision when you insert a record and insert in other databases..

stored procedure in SQL , how do i call it in NAV?

mohana_cse06

using ADO connection..
Search the forum..

julkifli33

so must use webservice?
or just create stored procedure in SQL and then call from NAV ?
i tried search, but still confuse

mohana_cse06

No need of webservice..

julkifli33

if we use stored procedure... we should set database 1 as database master,do we?
the case is... if in database 1, user insert new customer, it should be inserted also in database 2
and the other way around... if user insert in database 2, database 1 need to be inserted too

mohana_cse06

Why do we need to set master?

julkifli33

mohana_cse06 wrote:

Why do we need to set master?

is it simpler without database master?
i thought it's easier to set database 1 as database master for example