Quote Originally Posted by cfisher
This maybe a little late in replying, but what I do is date/time stamp when the last record was saved/updated. When the data is viewed to the screen, each row has a date/time stamp of when it was last updated. When they go to perform the update, I check to see if the date/time stamp still matches what's on the screen. If it does, then the record has not been updated since the user viewed that records and it's safe to update now (also update the date/time stamp). If the date/time stamp does not match, then I don't allow the update. It's not 100 % fool proof, but it's pretty close (it eliminated allot of problems here). I can provide more detail if needed.

Chris
This is the way I have always done it in the past as well. Having a business layer helps with this as you can put all the code to deal with the checking of dates and times in there.