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,
>
>A view is an image of the data at a specific point in time. Views are not connected to their data source tables in real time. When you TableUpdate the view it writes its data back to the source tables. If you have other views that are getting their data from the same source tables then you must
>
>Requery("EachViewByName")
>
>to tell the view to go and get new data.