In article <20021028094338.87249.qmail@...>, Antonio Parrotta wrote:

> Hi Nick,
> Since you talk about external tables, how can I create that kind of tables?.

Create table tablename external "c:\tmp\mytmpdb.gdb"
<col def> etc

> Please, suppose to have two database: "master" and "client", now "master"
> contains a table "products",
> "client" contains a table "customers" that have a field "productID" that
> should point to related product ("product" table to the "master" database).
> So I ask to everyone, is possible to make in the "client" database an
> external table that point to "master" "product" table?
> thank so much to everyone.

Yes, just make sure you use the same definition in both databases.

> Antonio
> ps: I don't need to update that external table, I need to create just a
> view that join the "customers" table and that "external"

it should work, but performance will be lousy. Set it up so that the
smallest table (of products & customers) is the external one.