Database design ideas or templates...

Hi, I'm not sure if I'm posting in the appropriate group but here goes...

I'm currently in the process of designing a new warehouse management system from the ground up as our old one in MS Access is inadequate, slow and poorly designed. I know I'm not the first person in the world with the requirements I have so I am looking for some database templates to get some ideas and avoid having to reinvent the wheel.

The basic requirements for the database are that it store transactions made so that to get a current inventory count need to add up the inbound and outbound transactions. This is to say that it be auditable. Another requirement is that products cane come grouped and can be manipulated with one group ID or handle for convenience but in outbound transactions it should be possible to send only a unique product from a group.

Thanks before hand! Received on Wed Jul 19 2006 - 20:03:05 CDT