After finishing my previous step now I have a query of how is best to structure the data and create a form.
I can structure the date in the below two ways.
1st Way
ID (PK) Initials (FK) Product Type Score Comments
2nd Way
ID (PK) Initials (FK) Product1 Score Comments Product2 Score Comments
I know for sure that there will be only 4 kinds of products and they will never increase. The thing is if I use the first way I do not know how I would structure the Form so that it would show all 4 products and have bound fields to fill in their score and the comment. Any ideas on how I should structure it ?
Thank you for your help in advance.