>I have a view which I'm using to pull aggregate data from various tables.
>
>I want to append that data as is into a separate table. I set up the view to pull from table1 and table2, and to save to table3. It doesn't work. I set all the update fields to represent the fields in table3, and set the fields to updatable.
>
>Is this something that is possible to do?
>
>To work around it, I created a separate view based on table3, which I load with nodata, append in the first view, then save it. I'd like to be able to do it all in one step.
>
>Thanks,
>
Hi David,

What about

Select Table3
APPEND FROM (DBF("myview"))

BTW, It can be done easily in Sql Server

INSERT INTO MyTable  (PriKey, Description) 
       SELECT ForeignKey, Description 
       FROM SomeView