Yes, committed to a temporary table. Once all records and fields are validated and user has requested to save, the data is add to the actual table and previous records of the same key are removed. (Child records). The validation checks range, the inter-field relationships and business rules. If the user has left the field blank, validation is not required until a save.
This is code I could re-write however, the code is xbase and still valid in the VFP6 context, so I don't need to reinvent the wheel if the validation can easily be overwridden in the situation I have described.