Jason, may I check and understand a next part, please?
Above you outline creating dynamic menus in DataAssist. I have also found, in the Dreamweaver Server Behaviors panel, WebAsssist -> Dynamic Dropdown -> Create Dynamic Array. (I notice this latter apparently is javascript.)
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.