>Using Foxpro 2.X, whenever I used a table in a multi-user environment, I would use an array filled with the scatter blank command to accept the data, then after confirming the information, a record would be added, and the information would be gathered into the table. I'm currently converting one of those applications, order entry, and finding it difficult to use the same approach. It seems difficult to use an array member as a control source for a text box on a form. Am I approaching this task the right way? When you use the table fields as the control source, it seems more circuitous to check for existing order numbers before saving, etc. Then if the user aborts the action, you have to unwind the whole process. Is there something basic that I am missing?
>
>Thanks in advance
>Carmen

Hi Carmen!

Use buffering feature of VFP and you can get rid of scatter / gather memvar in saving data. If your table is buffered you can directly use it as controlsource in your controls with the exception of the known key fields.

The following are related functions for your needs:

CursorSetProp()
TableUpdate()
TableRevert()