Hi Asteropi,
I create cosmetics and soaps and such. As such I need to keep track of the ingredients I use and what lot I put in each batch I make, so if for example a manufacturer calls me to say hey please return this lot, it was bad, then I should be able to track in which batches I used it and to what clients it went to.
So I'm trying to take my batch system on access but I'm baffled as to if there is a better way than what I came up with so far

So I have XX products. And each product has its own YY batches. And each batch needs to show the different ingredients, their producers lots, their % per use, date etc

The way I thought of doing it is to make a batch table and have a field for which product it connects to. so far so good.

Next: have an ingredient table to register the lots I buy
so pex, ingr 1, lot 1, manufacturer 1,
    and ingr 1 lot 2, manufacturer 1 etc

then have a usage table to register all the ingredients I use in each batch
so each batch would take like 7-8 lines to register
pex line 1: batch 1, ingre 1, lot xx, %xx
    line 2: batch 1, ingre 2, lot xx, %xx

And going to queries:
searching of customer's purchases, button to lead to batches and then button to lead to ingredients' lots

I know it's extremely complicated like this, and I do hope someone can understand what I'm describing here to tell me if this is the way or if they have a shortcut?

Thank you all,
Asteropi