Multi databases problems?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Oded Dror - 03 Mar 2006 12:50 GMT

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

Reply to this Message

Adam Harding - 06 Mar 2006 08:46 GMT

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

> Hi there,
>
[quoted text clipped - 10 lines]
> Thanks
> Ed Dror

Reply to this Message