Mark,

Not quite correct. User 2 has a copy of the invoice and user 1 deletes the record. When user 2 tries to save their work SQL server will fail the update because the record no longer exists and you need to handle that failure for User 2.