I have a combo Box which has unique transaction number. When the user selects any transaction number it should be locked and the other users when select the same transaction number should get a message saying Locked by other user. I am using SQL server 7.0. The related data comes from 3 diffrent tables having joins and the unique Transaction number after selection.
Any help would be appreciated
Thanks
MH
