Gerry,
The click was in the form not the grid, but grids are rather insistent on having their RecordSource as the current workarea whenever it has focus. Frankly I can't envision a use case where two columns of a grid need to be based on two different cursors.
There are just so many other ways to accomplish the task that don't involve multiple cursors IMHO SET RELATION is one of those 2.x style commands that ought to be deprecated. There are a few places I use it from the command window while browsing related tables in an investigative mode.
>That's not the problem; the Grid isn't able to refresh properly when he "clicks" on it because his Click event keeps selecting a Cursor that is different than his RecordSource.
>
>There is not practical limit, that I have found, for "relations in a grid" (I do it all the time except for the simplest grids).