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.