When should you use an oil based paint and when should you use a water based paint?

Oil base is the best for exterior painting. Water based chips after a few years, while oil has more of plastic coating effect and will need repainting maybe ten years down the road. It's also good for inside walls if you have kids. When it drys it still looks wet, sort of. It's easier to clean hand prints or coloring off of.