I have a grid with two lookup columns; I’ll call them ColumnA and ColumnB.
ColumnA is always bound to a BindingSource which is populated based on criteria selected outside of the grid (a Company dropdown selection in this case). This works fine.
Lookup ColumnB is bound to a different DataSource than ColumnA. Its binding is based upon the user selection in ColumnA. This needs to be done on a row by row basis.
In a nutshell, when the selected value in ColumnA changes, ColumnB needs to be re-bound. How do I accomplish this?
Thanks much in advance!