I’m looking for a little advice on a project I’ve been asked to do for the company I work for.

What they are looking for is a service management system that will track the status of fault calls logged by our customers, basically I need to record the date / time the call was logged, the fault details and then the status of the call until it’s complete (users of the system will update the call history so a complete audit trail of the call is available).

I have a fairly good idea how I’ll go about this but what I’m unclear on is the fact that multiple users will be using the application at the same time. The data will be on a SQL server, can I just load the app onto each users PC and let them get on with it or do I need to link the users in some way to stop people working in the same record at the same time ?

I've never done anything with more than one operator before so I'm not too sure on this aspect.