>>I hope this is complete enough for suggesting solutions and where to get information am multi-user. multi-table updating.
>
>The most obvious problem (IMO), is that there is no "error-handling"; ie. there is no testing of return codes from RLOCK() or TABLEUPDATE() which would indicate whether or not an operation was successfull or not.

I did NOT write, but I need to fix it.

Can you please give me some pointers on what needs to be changed, i.e either code snippets or where to get the information on the necessary error checking and anthing else I need to do.

This what I found in main program that seems relevant

SET LOCK	OFF 	&& Prevents automatic locking of reports, counts,
		&& labels, etc
SET MULTILOCKS ON && Allow multiple records to be locked at once
SET AUTOSAVE   ON && Specifies that buffers be flushed to disk whenever 
		   && you exit a READ or return to the Command window.
SET REPROCESS TO 10 Seconds	&& How many Seconds VFP attempts to lock a record

Are there other set commands I should be looking for