I see no reason to have a table for your form. You should use a query for the subform, and if the design requires it, another one for the main form
Also, advise the following
qms function should be unique index so that function name can only be there 1x?
consider unique composite index for qms-id & question id in junction table so that question can only be 1x per function
no spaces, special characters in names (save for maybe underscore)
Last edited by Micron; 02-21-2018 at 07:25 PM.
Reason: clarification
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.