Ok, the query

>SELECT 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)

has the MasterSource property connected to the datasource of the IPLOOKUP
table (which is the table being browsed).

I have changed the KeyLinks property to ID (being the unique field on the
joined datasource).

I just want to confirm this is correct because I get the same end result
whether KeyLinks is:

a) ID

b) SD_IPLOOKUPID

c) SD_IPLOOKUPID=ID

Please say Yes!!! this time <trembling <g>>


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