2 quick questions :

1) How do I keep multiple users from editing the same record without locking the entire table? What would be a 'standard' way of handling this?

2) How do I keep 2 people from posting the same record?

Please help me understand locking, THANKS!!!