>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")
TableUpdate(1,.F.,"View2")