Dion,
your SQL seems just fine - excepting that I can only see three candidates for LookupCombos (I assume you have sensible indexes defined). You are
using a TIB_Query, aren't you (I got a bit confused when you said 'Source Table')?

There's of course a bit more to using LookupCombos in a grid, but you've hopefully read about all that in the Getting Started Guide.

Set

Dion wrote:

> Hi all,
>
> I just need confirmation as to the efficiency of the SQL code in the Source
> Table. I placed the 4 TIB_lookupCombo's in a grid:-
>
> The Source Table reflects the relationship between MARKETER, FUND,
> OPTION(FUND) and GROUP.
>
> SELECT
> PERSONID
> , OPTIONNAME
> , FUNDNO
> , GROUPNAME
> , MARKETERID
> , DOI
> , (SELECT NAME
> FROM FUND f
> WHERE f.FUNDNO=m.FUNDNO)
> AS THEFUNDNAME
> , (SELECT FIRSTNAME
> FROM MARKETER a
> WHERE a.PERSONID=m.PERSONID)
> AS MARKETERNAME
> , (SELECT NAME
> FROM GROUPS g
> WHERE g.NAME=m.GROUPNAME)
> AS GROUPNAME
> FROM MEMBERINFUND m
>
> WHERE (m.PERSONID = :APERSONID)
>
> Thanks,
> Dion.
>
> >
> > Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
> >
> >
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/