Data insert issue if multipe user insert data through same application using single databasei have developed application called Marketing, if we insert data through that application from multiple computers at same time then duplicate data creates.
when user open the enquiry screen i am displaying Enquiry Number at text box and other controls allowed to enter by user.
in enquiry form i have Enquiry Number(included prefix "Enquiry") like :"Enquiry-001" and after save Enquiry Number will be "Enquiry-002" to enter next enquiry
issue is if multiple user opens the same screen by different computers at the same time then it will displays "Enquiry-002" if those user saves the enquiry it will be saved as Enquiry-002 for all user so it will like duplicate enquiry in database(for all user Enquiry Number saving as Enquiry-002)
what is the solution for this issue.