On Tue, Feb 4, 2025 at 10:05 AM Rich Shepard <rshepard@xxxxxxxxxxxxxxx> wrote:
On Tue, 4 Feb 2025, Ron Johnson wrote:
> Does your lookup table just have one column? (That's what your question
> seems to imply, but that makes no sense, since the whole point of a lookup
> table is to store some sort of a code in the "child" table instead of the
> whole text of the description.)
Ron,
Yes, each has a single column of type names, industrytypes and statustypes.
I've always used the descriptive names in queries.
Yeah, that's definitely Bad Design, for the reason David enumerated.
In the lookup table, the PK can be either synthetic (an integer that means nothing) or natural (a short text code, typically four characters) that is an abbreviation of the description.
Synthetic keys have been the norm for the past 25+ years, but I have a soft spot for natural keys.
Natural keys become unwieldy, though, when more than two columns are required to define primality.
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!
