Svein,
probably my implementation isn't sesible in Firebird, but I cannot find out any solution except that one I'm using. So if you have read my previous posts and if you know something about the design I described before, please get me a Firebird compatible solution.
Antonio
Svein Erling Tysvaer <svein.erling.tysvaer@...> wrote: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.

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

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