Anybody have any experience createing an inventory table that uses FIFO?

[eluser]megabyte[/eluser]
Well I have successfully created a simple inventory system that tracks purchases and usage.

If anyone is interested I am happy to share the code in hopes others might be able to refine what I have done.

I think my system is pretty decent but I know there are far more skilled developers than I.

It uses the FIFO (first in first out method) and stores all usages grouped as a single transaction so that they can be updated as a group.

Thanks.