Larry, Emmit, Dennis, Karen, Jim, Doug: Thanks much for your wisdom on this.
My "self-tutorial" schema is already two-thirds "z" (eg: zcounty, zstate, zzipcode) lookup tables, and I'm wondering at the coding load required to maintain and access those tables. Any which way, there's work to be done. >From what you say, there seems to be a workable middle where integrity, flexibility and performance may just possibly meet. Larry: Do Karen and Doug's approaches adequately address the integrity issue? Doug: Do you see a performance issue? My weekend is now complete! Yours, bruce chitiea safesectors inc. > -------- Original Message -------- > Subject: [RBASE-L] - Re: Schema Design Question: Look-ups > From: Doug Hamilton <[email protected]> > Date: Fri, September 03, 2010 3:21 pm > To: [email protected] (RBASE-L Mailing List) > > > Why not use a Master table ...
