My 47th rule is that your program must protect the users from themselves.

Before I would determine how to handle multi-user issues, I would start with the business rules and then compare this to the existing database structure. For example, if you only lock records in the current table, what if someone else locked the parent record in a different table? What if they actually DELETED the parent record while you have the child records?

You would not even think about this is you weren't aware of the overall data relationships and how things tie together. At least, that's the first thing that comes to my mind.

Art
http://members.aol.com/ARTGR