Hi Al:

Thank you for your response.

>In general the use of RECNO() in SQL commands is unreliable; VFP may open other instances of your table(s) in unexpected order(s). If you look closely at your table you may actually find that a record other than the one you want is getting updated.

There is only one record in the the Clinic table.
>
>Instead, each table should have a primary key and you should update based on that key.

I don;t have a primary key there because the clinic numbers and group numbers are hardcoded during production.