View Single Post
  #18  
Old November 14th, 2005, 12:26 PM
external usenet poster
 
Posts: n/a
Default Question about a default table or method


Allen Browne wrote:
It might be better to create a more
generic table with fields such as these:
TheVariable Text The name, such as "SalesTaxRate".
TheUser Text Zero-length string if it applies to all
users.
TheValue Text The current value to use for this variable
DataType Long A value that is a member of vbVarType
Descrip Text Description of what this variable is used


Sounds a bit too close to the "One True Lookup Table" design flaw to
me:

http://www.dbazine.com/ofinterest/oi-articles/celko22