>I have a column in a grid bound to 'mach_num', which has the Column1.CurrentControl set to a dropdown which has 2 columns (mach_num, mach_name) used for input. All this work fine... But, I also have a textbox defined in the Column that I want to display the machine NAME (not the number) after the column loses focus. But since the Column1.ControlSource=mach_num, the textbox shows the machine number from the table, and not the machine name which lies in a Related table based on the mach_num field.
>
>The relationship is in place, but I can't make it work.
If the BoundTo property of the column is .T., then it may be forcing all controls in the column to have the same ControlSource value as the Column.
You could try setting BoundTo to .F., and set the textbox ControlSource to None. You could then manually populate its Value from the LostFocus of the Combo.
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up