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.


Malcolm Smith
MJ Freelancing
ABN: 30 671 763 146
http://www.mjfreelancing.com