I have a need to switch the control source from one row to another with in one column of a grid. What is going on is that I have a table in a relation with two other tables. Depending on a key in the main table I will need the company info from one of the other two tables displayed in a grid. The trick is that it will change from one row to another. Any suggestions?

Thanks
Kelly