Multi databases problems?

[Oded Dror]

Hi there,

We are using Microsoft Solomon 6.0 on SQL server 2000, InfoPath 2003 SP2
Also we are using Custom made program with msdb database
The custom made program stays in our showroom and after several calculation
It produces Item ID that = to Solomon Item ID So we entering it twice
(typical scenario)

My question is there any way to develop a form with InfoPath that take the
data from one
location (msdb) and submit (Items number) into Solomon Inventory Module

Thanks
Ed Dror

 

[Adam Harding]

Hi

Potentially yes

if the msdb was the main datasource then an action could drive the pulling
of data from the solomon DB and then push it into the main datasource.

If you wanted to automate it you would need some code.

As an aside what prevents you making this even more simple. Link the
solomon table into the MSDB and use queries to do the jobs you require.
Simpler still

Cheers Adam