Subject Re: [IBO] Lookup List
Author Helen Borrie (TeamIBO)
At 07:02 AM 15-01-02 +0000, Lester wrote:

>Clear head, and try again.
>This is just a matter of my understabnding lookup. I have
>had the lookup working with PARTLIST joined to ORDER_ITEM so
>that DESCRIPTION from PARTLIST is is displayed linked to
>PARTNO. But in the final setup, I don't want the join at
>all, just the list of PARTNO to select the insert into the
>I was 'playing' with all sorts of bits yesterday, so I can't
>see the wood fro the trees, and can't see an example of the
>'simple' look-up.
>So the question is probably - how do I set up a simple list,
>or do I have to have the join?

No, not a join - use a correlated sub-select on to fill that Description field in the main dataset, and use KeyDescLinks to link the lookup list's Description column to the sub-selected column.

If you have the GSG, there's a full walkthrough in there; otherwise, get "Working with Data-Aware Controls" from the TechInfo page, which provides a less detailed outline of the steps.

Helen Borrie (TeamIBO Support)

** Please don't email your support questions privately **
Ask on the list and everyone benefits
Don't forget the IB Objects online FAQ - link from any page at