Thanks, guys. I am still a bit torn. Good news is, every lookup list is generated by an ADO call to an sproc called "GetLookupValues(strType, strCondition")" -- so, if, a few weeks into development I change my mind on the approach, I only need to change code in one spot.
>To add to Mark's thought - it's not long before the app mutates and you have to start tracking additional information for a subset of the items in the table. For example, maybe you start with a list of the available shippers and then you have to add a weight limit.
>
>IMO, go with the individual reference tables.
>
>-Mike
The whole problem with the world is that fools and fanatics are always so certain of themselves, but wiser people so full of doubts. - Bertrand Russell
