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