Dan:

When you have a child table directly bound to a grid it can appear "buggy". For example, try to refresh grid bound to a child table with the cursor in it, nothing happens. It won't refresh until the cursor is moved to another object. This and a lot of other stuff made me rethink how I use grids. Especially when relations are involved.

Nowadays, I really don't use the grid control at all, instead I'm using mostly lists. In my base list class I create an array property. In the requery method I fill the array from a query. To manipulate the control contents, I use the list funstions. To refresh the list, I call its requery method. Its all encapsulated.

Now that I've added the extra layer of abstraction between the control and data, I find everything works much better. I can freely move the record pointer in the underlying table without disturbing the list and vice versa, refresh problems go away, EOF and BOF problems go away and so forth.

BTW, I went to the Little League World Series Baseball Camp when I was a small child in the early 70's in Williamsport. I remember playing in the stadium.

Charlie