Hi Woody,
how can I link the tables? can you explain me more clairly please? take in mind that I need for queries that join two or more table that resides in different database. Suppose to have a table "product" in the master db and a table "customer" in the service db. How would you make a query that list the customer name and the related product name (the "customer" has a "productID" field)?
thanks so much
Antonio
Woody <woody.tmw@...> wrote:>

> Helen,
> I try to clairly explain you what I would like to have:
> the problem is that I need for this strange arrangement since I have some

tables that are "common table" and some other that depends of kind of
"service" that has to be managed. So I have only one "master" db, and many
"Service" db, I don't know how many "Service" db I can have, but each
"Service" db will have all the master tables plus other tables. Again, all
the Sevice tables that refer to master, must contains the same data for all
the Service dbs. I have already created and tested an Delphi application
that works on a Access database. Using the linked table, I'm able to obtain
what I want, but since my database going to be "too big", you know that
access will become unuseful (performance very slow). So I'd like to migrate
to Firebird, but before that, I need to know if it meet to my aim. So, it's
possible to simulate the "access linked manager" with interbase or firebird?

> Many thanks
> Antonio
> ps: IBReplicator (or other similar tools ) I think can solve my broblem,

but I'd like to solve this problem via "query" if possible

As long as you don't need to enforce relationships internally in the
database, then you can link tables in separate databases all day long
without problems. I do this all the time. You just set up a database
connection for each database. Then just use normal queries tied to the
correct database. You can either provide your own mechanism for controlling
the linking, such as opening and closing the query while changing it's SQL,
or, if using Delphi or other language that has datasources, you can tie them
together using that as well.

Woody (TMW)




---------------------------------
MIo Yahoo! : personalizza Yahoo! come piace a te

[Non-text portions of this message have been removed]