how do i set up a inventory in access with recipe type data

[John Vinson]

You'll have to give us a bit more information than that. Feel free to
use the big white text area, not just the subject line; and be aware
that you're talking to real human volunteers, not to a search engine.

What kind of recipes? Home kitchen? Industrial asphalt formulations?
Mass market prepared foods? Institutional kitchen?

And what do you want to inventory: ingredients? final products?


John W. Vinson[MVP]

 

[recipe type data]

sorry about that.i have rubber compound recipes that i need to keep inventory
on the ingrediants.all of the ingrediants are based on the parts per hundred
system.i have all of the recipes in excell and the spreedsheets do a good job
with the recipe calulations for batch sizes.one customer might want a
thousand lbs of one compound and another might only want five houndred.so i
would like a way to automaticly subtracted the wieght of the ingrediants
that i am using from my inventory.