I have to create an inventory warehouse system.
I already have the main tables done, What I need is a couple transaction tables and maybe a current inventory table. I also think Triggers will be needed.

What it needs to contain and do is the following:

> Basic Warehouse system

> Maintain Inventory

> Reports of what came in and what went out
  also what is still in the warehouse for that product ID.

> History of Inbound shipment.
  Example: I need to keep an updated inventory table of what has come in and gone out and still in warehouse by product code, But I also need to be able to look back and see everything that came in on a certain day, or a certain shipment.

I think I have an idea of how to do, but when I try it, something goes wrong with logic. Just kinda looking for an new idea. Something to get me thinking out of the box,

Thank You in advance.

Are the things you need to track individually identifiable (like by a serial number), so you have a record for each item? Or is it more of a 'this parts bin contains 200 9-pin D connectors of type X' kind of application?

Steve

"Every program can be reduced by one instruction, and every program has at least one bug. Therefore, any program can be reduced to one instruction which doesn't work." (Object::PerlDesignPatterns)