Thanks to you guys I have been able to get my first application halfway going. But I have a question about data integrity.
The application that I am developing utilizes a single sql server and multiple work stations accessing that sql server.
What is the best way to maintain data integrity? If user X is editing record 20 and user Y is editing record 20 at the same time, whoever saves the data last wins. That's not a good plan.
I was thinking about having records "locked" when they are edited, or something similar to that. Maybe making all records read-only unless you "check out" the record for editing....how have you guys handled this in your applications?