Hi all

I have generally handle inventory systems so I am generally aware of the basic theories. Now I have to plan for a Inventory database for a Pharma company and the items have the following specs.:

- Each item has it own stock (obviously :)). For eg. Liters
- Each item has it's stock distributed in various packing sizes. For eg. in bottles of 50ml, 100ml and 500ml
- Each item has the above stock further distributed into Batch Numbers

Making them create as a new item (new internal unique id) for each and every packing size may raise complaints and asking anything similar for Batch Number and I am sure to loose the contract.

Can I get some database ideas regarding this wherein I have one internal unique id for an item and yet be able to records transactions that can aid me in providing details and stock for a given batch number or a packing size.

I hope I have been able to explain my thoughts about the requirement.

Please advise.