>>There is no record locking in SQL Server as in VFP. You can use query hints in order to achieve some locking, but I don't think it's a recommended approach.
>
>So what is the recommended approach ?

Let SQL Server apply locks as it sees fit.