Hi,

I have two datasets, the mainset defined as

SELECT SOCIALSECURITY
, DATEOPENED
, RETAINERREMAINING
, HOURSASSIGNED
, CERTNAME
, (SELECT CERTDESC FROM CERTIFICATION WHERE
WORKINGDOCKET.CERTNAME=CERTIFICATION.CERTNAME) AS CERTDESC
FROM WORKINGDOCKET

and the lookupset

SELECT * FROM CERTIFICATION
ORDER BY CERTNAME

Keylinks: CERTNAME=CERTNAME
KeyDesclinks : CERTDESC=CERTDESC

Everything works as expected except for one thing. When I change the
underlying dataset (referred to as lookupset here) and then edit a
record in the mainset, the description field (CERTDESC) does not
update until I change the lookup dropdown and change it back, OR
disconnect and reconnect the dataset.

So the question is, how do I make the keylink fields update
automatically when the underlying dataset is changed? I'm probably
just missing a property somewhere.

Thanks,

Jason S. Gagnon