[thelist] inventory database design question

Richard Bennett richard.bennett at skynet.be
Sun Mar 9 07:46:01 CST 2003

----- Original Message -----
From: "rudy" <r937 at interlog.com>
> if you are thinking of calculating profit, which i suspect from
> column names like PriceIn and PriceOut, you just have to be
> careful how you handle nulls in the serial number
> FIFO works in sql, but it can get complicated if all you have
> is the dates that the inventory came in

Thanks for reviewing that..
I'll keep your comments in mind as I refine it.


More information about the thelist mailing list