>Jim,
>
>Is what I listed in my previous message the correct way of doing it?
>And what is the sequence for tableupdating and requerying. Do I do a tableupdate on the view that is created from the Primary Table first and then requery then do a table on the next view created from the child table and do a reuery etc. or do I do a tableupdate on all views beginning with the view based on the primary table first and then requery?
>Does it help to know the error I'm getting now is: 'Table buffer for alias CHILDVIEW contains uncommitted changes'.
>I can't believe how long I've been working on this and how discouraged I'm getting.
>

Mary-Ann,

It sounds like you are dealing with double buffering. Let me explain it in a simple example and you amy be able to see it in your situation.

Given two views, the first view is from a table and the second view is a join of data from the first view and another table. I write this code;

TableUpdate(1,.F.,"View1")  && View1 writes its data to the table
* At this point view1's buffer is clean

TableUpdate(1,.F.,"View2")  && View2 write its data to the table and to View1
* At this point view1's buffer is dirty again