Re: Database design ideas or templates...

Paul <paul_at_see.my.sig.com> wrote:

> > 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.

> You didn't mention your db of choice. Nor your OS. Nor your RAM.
 

> If you wish to go with Oracle (and maybe PostgreSQL) and have a small
> system, you might want to look at www.compiere.org which is an ERM
> system for free.
 

You could also try this link if you wish to run it on Firebird (a cheaper and less resource-greedy db server than Oracle, in fact it's free, even for commercial use!).

http://www.janus-software.com/compiere_dl.html

Paul...

> Paul...

-- 

plinehan __at__ yahoo __dot__ __com__

XP Pro, SP 2, 

Oracle, 9.2.0.1.0 (Enterprise Ed.)
Interbase 6.0.1.0;

When asking database related questions, please give other posters 
some clues, like operating system, version of db being used and DDL.
The exact text and/or number of error messages is useful (!= "it didn't work!").
Thanks.
 
Furthermore, as a courtesy to those who spend 
time analysing and attempting to help, please 
do not top post.