ADO Recordset: Joined Table Fields Do Not Refresh

[dpatrickcollins]

Hi All,

I am running into the following problem. I have an ADO recordset which represents a rather typical query of two tables, one a look up (One-side) of the other as follows:

Select Table_Many.ForeignKey, Table_One.KeyDescription
FROM Table_Many, Table_One
WHERE Table_Many.ForeignKey = Table_One.UniqueKey

Problem is, when I do an 'AddNew' and populate the "ForeignKey" field of the new record with a value, the "KeyDescription" field is not automatically populated, which I would expect. Why? And How to properly get around this?

 

[dpatrickcollins]

BTW, I am running VB6, using DataEnvironment to set recordset, but I do not think that should matter too much.