--- In IBObjects@yahoogroups.com, "jeffplata" <jeffplata@...> wrote:

>
> (Using IBO 4.5B)
>
> Is it possible to define a lookup relationship using

keylinks/keysource

> between two ib_queries where one gets data from a stored procedure?
> Something in this manner:
>
> mainquery:
> sql='select gl, sl, dramount, cramount from rp_tbsl(:period)';
>
> lookupquery:
> sql='select gl, description from accounts';
> keylinks='accounts.gl=?????? // what goes here?
> keysource=ib_datasource1
>
> ib_datasource1:
> dataset=mainquery;
>

If this kind of lookup relationship is not possible, what is the IBO
way of achieving this effect?

TIA