Jason, may I check and understand a next part, please?
When to use one, and when to use another?
(And since overdue, let me notice that, in my newbie-ness, I misstated - in the initial post in this thread - and suggested that lookup tables share the parent table primary key. That is incorrect generally. It is one-to-one relations, typically with subset tables, where the primary key is shared.
(Important to make this correction for any future reader of this thread. I will add a correction to my misstatement in the original.)
Thanks as usual. And best of the holidays.