[thelist] inventory database design question

[Richard Bennett]

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

Richard.