database design
From: the fat heffer <iamthecow_at_NO_SPAMhotmail.com>
Date: 2000/08/11
Message-ID: <965987747.21754.0.nnrp-08.9e981bb7_at_news.demon.co.uk>#1/1
Date: 2000/08/11
Message-ID: <965987747.21754.0.nnrp-08.9e981bb7_at_news.demon.co.uk>#1/1
i have a question about the design of a current stocklist table in a
database.
which of the follwing two ways is correct or is there another way of doing
it.
1st method
have one stock list which each record havinn a shipped tick box.
and if it has beeen shipped it is not included in a current stock query but
it is still in the main stock table.
2nd method
When an item is shipped move it form a current stock table to a shipped
stock table. so that there are separate tables for current stock and shipped
stock.
Which of these two methods is better and which is the standard method that
is normally used.
or is there another way of doing this
thanks
Received on Fri Aug 11 2000 - 00:00:00 CEST