Database design ideas or templates...
Date: 19 Jul 2006 18:03:05 -0700
Message-ID: <1153357385.658621.103740_at_m73g2000cwd.googlegroups.com>
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 Thu Jul 20 2006 - 03:03:05 CEST