Existing functionality:

user A enters the form first, makes some changes,

after sometime user B enters the same form. Now

user A clicks "Save", and is still in the form.

now if user B has made some changes and clicks

"save", his changes should be reflected, and it

should be saved.


Desired Functionality:

If user A gets into the form first, then as long

as he is in the form, only his changes are final,

if user B enters the form after user A, and clicks

"save", his changes should not be saved( as long as
A is in the same form)

some message should appear to B indicating that someone

else is using the same form and has a higher
priority over B.

NOTE: DATABASE IS MYSQL, FRONT END IS VB6.