See "Display child records from a relationship" on soluction sample (controls--> Grids-->Display child records from a relationship)

>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