All:

Look-up tables proliferate like computer cables. Remembering my kids'
names is hard enough.

Wondering if there's a simpler approach, balancing coding complexity
with performance:

Anybody have thoughts/experience regarding two approaches:

1) individual look-up tables - each dedicated to a specific 'idea'
(category);

2) a master look-up table - all 'ideas' contained within a category
field - look-ups being performed through where-clauses targeting the
specific category.

zMasterLookUpTable
zCategory - (Indexed) Where-clause target
zData - (Indexed) Data values
zSortOrder - Category-data sort order

Just wondering.

Appreciating all you all do for all of us,

bruce chitiea
safesectors inc


Reply via email to