I have a form (form1) containing parent records (view1) and child records (view2) that are in a grid. Form2 edits the children, Form3 edits the grandchildren (view3). In form1 init, I requery view1 and all related view2 records. In form3 I requery grandchild records related to the child (view2) that is selected. The problem is that when I switch children I always have to requery the grandchildren. That means that I have to tableupdate or the changes will be lost. I don't want to tableupdate at this point though. I want to tableupdate at form1 so view1, view2 and view3 changes can be backed out if I want. So do I have to create an intermediate view (view3all) that contains all grandchildren of view1, whether or not they relate to view2, then requery view3 from view3all records as needed? That way I can send the view3 changes back to view3all and back them out or save them in form1. Is there an easier way?