So, if you don't lock, how do you prevent people from changing the same record. I know there is a way to set the WhereType and compare updated fields, etc, but in the end, if 2 people are making changes to a table, someone is going to lose out. How can we prevent this????

TIA
Mark