Although you CAN set up this type of process in Access, Excel or use
VBA automation to roll your own...you might want to check out the
latest version of Quick Books...that is exactly what the program
does...handles inventory, purchasing, billing, costs, and such for
small businesses...works great. They have various specialized version,
so make sure you get the one you need.
Good luck...
Dian D. Chapman, Technical Consultant
Microsoft MVP, MOS Certified
Editor/TechTrax Ezine
Free Tutorials:
http://www.mousetrax.com/techtrax
Free Word eBook:
www.mousetrax.com/books.html
Optimize your business docs:
www.mousetrax.com/consulting
Learn VBA the easy way:
www.mousetrax.com/techcourses.html