Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Table disign 1
- Thread starter WWinter
- Start date
-
1
- #2
HI
It depends on your total volume and the sequence to locate back easily. Any database is not just for input.. it should be convenient to retrieve data. On that basis, it could be in one table UNLESS they are of totaly different nature and follows different numbers sequence.
For an average place, I would think of a common table so that the PO number follows some sequence without hunting between differnt choices.
ramani
(Subramanian.G),FoxAcc, ramani_g@yahoo.com
It depends on your total volume and the sequence to locate back easily. Any database is not just for input.. it should be convenient to retrieve data. On that basis, it could be in one table UNLESS they are of totaly different nature and follows different numbers sequence.
For an average place, I would think of a common table so that the PO number follows some sequence without hunting between differnt choices.
ramani (Subramanian.G),FoxAcc, ramani_g@yahoo.com
- Status
Similar threads
