hmm, well it looks like there are a lot of unknowns here. It seems like the analysis phase was not completed.
Here are some things you need to consider:
* is this going to be a real time or batch oriented inventory system?
* are you using a database or a flat file system?
* how many users will be accessing the information?
* what kind of output from the system are you looking for? is this going to be a MIS?
Its an inventory system for shopwhere we hv to calculate total no.of stock,details of all items with their price for customer to select,if any article is sold or any item is bought it shld b taken into account,tht is total account shld b added or subtracted frm total list.
I your looking for what u need for developing an invertory application, have a look at the code at www.vbcode.com/code/GARAGEPROGRAM.zip . Its a carshop invertory application. It might give u some idea.
When starting a database projects it is wise to decide and design the reports first. You need to know what you want out of the program before you can decide the best way to store all of the information is.