Ken:

There is another way. Try creating two grids on your form. Just make one or the other visible/invisible when you trigger the search.

HTH,

--Paul

>Pardon this novice question, but I've worked on this for hours without results.
>I have a form with a grid that displays fields from a parent and child table and a one to many relationship.
>I want to trigger a search and display the results in the same grid. The search will require changing the relationships, parent and child cursors and change the tag orders.
>I've tried using code after the string search:
>SELECT clients
>set orde to alpha
>SELECT Pets
>set rela to idno into clients
>etc...
>
>Is there a way to programatically change the data environment to accomplish what I want or am I going about it the wrong way?
>
>I hope this makes sense and TIA.