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.


>>Hi Jim,
>>
>>The six views are based on six separate tables. One primary table and five child tables (1 to many). (I'll try to explain what I'm doing and what the problem is.) The form has a page frame of text boxes. The control source is a field from the view. I'm trying to set it up so that the user can Copy a current record. (our products are similar, so usually, the name, item number and a few other fields get changed, but the rest is the same.) I set the parameterized view variables to be empty and requery each view, then I Set Carry On and append. I create a uniqueid for each view and replace it in each view. At this point, my views all have a new record and the newly added record in each view has the same uniqueid as the Uniqueid is the Primary Index. Then when you go to the pageframe and fill in the fields, I have a thisform.mypageframe1.page1.txtField.refresh() in each valid. (I thought this refresh is what puts it in each view?) Then I do a 'Save' where basically I'm doing a
>>Tableupdate() on each view, beginning with the primary table. The Primary table is the only table that actually gets updated. The rest of the five views are empty with just the matching unique id in it. Please tell me where I'm misunderstanding.
>
>
>Mary-Ann,
>
>It may be me that is misunderstanding. I don't understand what you are seeing and what you want to see. It sounded to me like you did a tableupdate on one view and the other view did not show the changes from that update. The view won't show the changes until you Requery("TheViewName") to tell the view to go and get new data.