This isn't a subject to be taken lightly... inventory management is complex and frequently changing. It's not something that can be learned correctly in a couple of hours especially if you don't have a very, very good background in database design.
My suggestion would be to get some professional help on this one.
--Jeff Moden
Change is inevitable... Change for the better is not.