Dear Ken,

Thanks for your feedback and advise. I've another question need your advise. At first i SELECT all the data INTO CURSOR cMrsShare READWRITE and SELECT * FROM wrk_ordr WHERE date = {^1999/01/01} INTO CURSOR cWrkOrdr READWRITE (i need to create a blank READWRITE CURSOR, that's why i select the date on {^1999/01/01} ).

Then i click on THISFORM.Command1 (Update MRS) to update & insert records at m_updmrs.scx and save it on CURSOR cWrkOrdr & cMrsShare. My EndUser need to insert and update a lot of records at the same time. After they finish, i create another FORM to let them POST (Update and Insert all the records) all the records from CURSOR cWrkOrdr to fews database.

My question is :-
1. Is it the way to do that?
2. If a lot of data inside the CURSOR cWrkOrdr, take time to update & insert records. Is there anyway to change any method to doing this? Maybe need to change all the structure?

I'll resolve my previous problem by using SET MULTILOCK ON & CURSORSETPROP("Buffering", 5).

Thanks.

Regards,

Stewart Chew