Querie Help

[Gootz11]

How do I run queries from another database?
or maybe there is a better way to do this.
here's what i am trying to do.
I have one database that uses data from 18 databases,
I need to run a querie which updates the data in each of this 18 databases. I would like to create a command that would update the data for this 18 databases from my central database.
any ideas
Thanks in advance.
JG

 

[WayneRyan]

JG,

That's a lot of databases. If they don't move around, you could
use linked tables to reference them directly.

Wayne

 

[a.sinatra]

Or he doesnt know how to use FE & BE servers, and has a db on each users computer, because 18 db's i think is overkill.
________
M F L B

 

[Gootz11]

The reason i have 18 databases is that i have 18 different divisions in my company that function independently. They use the same version of the database but have a unique system for themselves,(since they all have different inventory) it would have been imposible to have them all in one database since one of this systems is around 50MB and is dealing with over 500000 records.
Thanks for your help anyway.