Criteria

I am not a programmer and would appreciate some help. I have built an app to control the rental of vehicles. I need to ensure that I do not duplicate the hiring out of a particular vehicle. I need to search the database and if a vehicle is already rented out, someone entering data must be prevented from hiring out the vehicle again. How can one achieve this?

Derek