Can someone please help me with ideas on how to accomodate a client request?

I have a online transaction with a substantial unit of work that reads many different tables. When the user selects a patient, they would like THAT patient locked from viewing from any other user. No other tables need to be locked.

Thank you in advance,
Bob

The application would need to be modified to change the issolation mode of both the updater and anyone viewing. The program that needs the lock would update the record, setting the lock.

Another option would be to set a flag in the record at the start and have all others check for flag being set.

Either way, it's a program mod.