>Thanks Sergey:
>
>But whats the best solution for what I need to do. I need to set up a tempary table, have the end user enter the data, review it and then append it to the main contribution table once they feel the data is correct.
>
>I thought that the bext way would be to fill a temporay table, then append from that table and delete the fields for the next entry.
>
>I am coming from an access background so I guess my though patterns are way off.
Jimmy,
Don't try to do stuff in VFP the way you used to do in Access. You would get nothing but frustration because VFP is quite different. VFP's not less capable but different.
There're very few cases in VFP where you would use a temporary table because VFP has cursors. It's basicly the same temporary table but VFP automaticaly deletes it after it's closed. You can create a cursor with CREATE CURSOR command, SELECT ... INTO CURSOR READWRITE and other ways. Because cursor is unique to the running application, you don't have to worry about conflicts with other users. You cannot use PACK on a cursor but you can empty it with ZAP command.
You can also use a parameterized view in the table buffering mode. Issuing Tableupdate will save records to the underlined table. Tablerevert will kill changes.
--sb--