SQL Inventory System

[jojo79]

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.

 

[stevexff]

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

[small]"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:erlDesignPatterns)[/small]