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.