>>One form is showing data from a related table; the table is selected through a relation in the DataEnvironment.
>>
>>When changing the foreign key through a ComboBox, the data from the related table doesn't get updated until the record is saved. Is there a way to update this BEFORE saving the record?
>>
>>TIA,
>>
>>Hilmar.
>
>Try to do
>
>goto recno() && to force the relation
I had already tried that - and the ComboBox (where I select the foreign key for the other table) reverts to its previous value, undoing any change select by the user. I used the ComboBox.InteractiveChange event, by the way. Or should I do this later, perhaps in LostFocus()?
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)