Hi,
I guess it is easier to restructure one small (thin) table, than the whole
T-table, when you add/remove new Status-values.
That may be a reason on some DB-platforms at least.
I would think that Status-values would be more fluctuating than actual
fields.
It was a long time ago when this design was implemented...
Best Regards - Misi, RRR AB, http://www.rrr.se
Products from RRR Scandinavia:
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
Find these products, and many free tools and utilities, at http://rrr.se.
> What would be the purpose of having a seperate table to hold the
> status values and not just have it in the orig table?
>
> -John
>
>
> Sent from my iPhone
>
> _______________________________________________________________________________
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
>
> --
> This message was scanned by ESVA and is believed to be clean.
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"