At 04:33 PM 05-09-02 +1000, you wrote:

>Helen,
>
>Thanks. I got it sorted in the end with this info.
>
>With my query as:
>
>SELECT DISTINCT GROUPS.GRP_DESCRIPTION,
> SPRITEDETAIL.SD_DESCRIPTION,
> SPRITEDETAIL.SD_CAMERA,
> SPRITEDETAIL.SD_IPLOOKUPID,
> IPLOOKUP.ID,
> IPLOOKUP.IPL_DESCRIPTION,
> IPLOOKUP.IPL_IPADDRESS,
> IPLOOKUP.IPL_LOCAL
>FROM SPRITEDETAIL
> INNER JOIN GROUPS ON (SPRITEDETAIL.SD_GROUPID = GROUPS.ID)
> INNER JOIN IPLOOKUP ON (SPRITEDETAIL.SD_IPLOOKUPID = IPLOOKUP.ID)
>
>(no WHERE clause)
>
>and
>
>KeyLinks: SD_IPLOOKUPID=IPLOOKUP.ID
>MasterLinks: SD_IPLOOKUPID=IPLOOKUP.ID
>
>and the datasource pointing to the lookup table
>
>all seems to be working fine now. I didn't need to use any
>parameters...does this sound OK.

No.
Re-read what I wrote last time.
Or just ignore it if you choose to.

HB.