Bonnie,

You will save yourself a lot of headache and coding if you just switch from the cursor to a view. You can freely requery the view without causing your grid to self-destruct.

>I can't seem to find a Requery method for grids, but it almost seems that I need to have such a method. I've got a grid based on two related tables, one of which is created in a form-scoped method with a SQL SELECT. When the screen is first activated, all is fine. But as soon as I call the method that re-creates the one table, the grid disappears ... it's obvious why this happens (because the table is deleted and then recreated) but now I need to know what to do about it. Any ideas anyone?