I add an array prop to my base list control. In its requery method, the data it needs is stored to an array, then array is used to populate list. This way the list is never bound (connected) directly to table. There is now an extra layer of abstraction.

I have an C\S application that pulls down investigative cases. Each case has lots of child, grandchild and great grandchild tables relations. Binding directly to tables caused me a lot of headaches with refreshes and other stuff I can not remember. Doing it this way was charm because you are decoupled from record pointer.

I don't use grids much anymore, but you can use a temporary cursor instead of array and achieve the same thing. Since I don't like users editing directly in a grid, I don't have much reason to use grids. I use lists.

Charlie