Oh, THAT idea!
Yes, pull one table in at once and use it to feed the values each form input requires.
It does make more work for ME on the filtering side of things.
I have to provide separate filter queries on the browser side to populate a checkbox group with 7 text options while the next form input has a different set of options, etcetera.
I know how this would work but in the time I was given to get it online for employees in the field to start using it – I went quick & dirty. A small table for each different form input to dynamically populate the checkboxes, radio buttons, sliders.
Then I didn’t have to write filtering queries to only expose the relevant rows & columns in a one table-fits-all dynamic source table.
Plus, on the Office Admin Dashboard I wouldn’t have to duplicate that on update inserts so that the Admin could quickly delete or add new dynamic entries to one category of input out of 10.
YET, what you suggest (I imagine that is what you suggest) makes plenty of sense. I will probably switch to this standard procedure this month on my next project!