How would I handle this scenario:
Goal:
Want to expose this through a form.
Customer A
This customer has several projects. With each new project I need to create new columns, because the information usually is different from project to project, so it’s very possible that I will not be able reuse a column later on.
Example:
Project #1, one Multiple Select is
“A”
“B”
“C”
then, later on, I create a new project #2, and it needs a different Multiple Select:
“1”
“2”
“3”
then, later on, I create project #3, and it needs two Multiple Selects:
Multiple Select #1:
“Answer one”
“Answer two”
“Answer three”
“Answer four”
“Answer five”
Multiple Select #2:
“Some text”
“Other text”
“Another text”
Question:
What is a best practice to create a database (and its tables) able to hold this information?
Should I create a “Customer A” table, and hold every project of that customer in there?
or would it be preferable to create a “Multiple select” table, and hold every type of multiple select question in there.
Also, this is just for one customer, Customer A.
Any guidance on how would I go and accomplish this for many customers?
Or can I use the “Multiple Select” column to keep any and all records?
So, my question is:
When using a form, can I select which fields I want to display, for that particular form, of a “multiple select” table?