Hi Peter ---

You're not being a pain at all...don't worry about it :-)

OK ---- Make sure *all* of the fields are checked off for update in the View Designer and ensure that Send SQL Updates is checked off in the Update Criteria Tab. If so, then the following simple example would work (try using INSERT INTO instead of APPEND BLANK -- it's more primary key friendly):

USE database!localview 
=CURSORSETPROP("Buffering",5,"localview")
INSERT INTO localview (field1,field2) VALUES (value1,value2)
=TABLEUPDATE(2,.T.)

Note that in the TABLEUPDATE 2=all records and .T.=Force.


>Please tell me if I'm being a pain, but as you know my limited knowledge of views I think you best placed to answer me, I've tried adding records to my view without success, is append blank followed by tableupdate enough?, the view buffering is optimistic table, I think what I'm missing is updating the key field

------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam.  Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05