Hi

I want to do a stock system that would reside on a number of
distributed databases .. say five. Each site has its own firebird
database. How ever it would nice that being on a vpn that a query could
be made to ctheck the stock levels of all branches in a single view or
table.
This may happen when you dont have stock but to refer a customer to a
store that does or request a transfer from a store
Are there any elegant techniques available to do this apart from
general ETL (Extract/Transfer/Load) methods to do this
or is building the table manually my only forte

Many thanx

M