Design with full traceability

[L'apprentis]

Since the latests post I have received from The Doc Man, Pat Harman and ScottGem I have been spenfding a lot of time on stock, really interesting and challenging indeed. (Thanks very much for the advice)

I've design a database with a working transaction table.
But by using this method, there is no way to have full traceability, how can i keep track of the advice note of each individual batch if i am using such a system? Is there any way to go round it?

Thank you,

 

[L'apprentis]

Thanx Pat,