Hi friends i need a help in my project?

Am doing a VB project using oracle8i as backend,my project is car showroom managment,i need some calculation about stock maintanence,If i order a particular car to a company the number of cars in showrooom should increase likewise if i bill the car no.of car should decrease can any one suggest any calculation.,