Antonio,
why do you have to use two separate databases? Having separate databases in
Access does not mean that the same is sensible in Firebird. Examining your
design may be yield far better results than tweaking your implementation.

Set

At 09:55 29.10.2002 +0100, you wrote:

>I know that way used from you, I started using lookup field. But since I
>have to use a grid to view the join query, then user need to sort the data
>by clicking on the column header. So this approach, as you know, does not
>work, because the related column field is an id and not the actual data (I
>use the lookup approach). This is the reason that constrain me to use a
>query to join the tables.
>I appreciate so much your help, I hope we can find a way to solve this
>problem.