Parent Table โ Child Table & Requests table with one request for each parent row with questions about some of itโs children. My employees submit requests to our clients which include certain child records selected via an Enum List. The clientโs respond in a form and I canโt figure out how to design it so that they can respond to each child individually via an Enum List. I know I could make a child record response table but then Iโd be creating redundant child records when all I need is a Yes or No Response. The outcome would be one Request Row with a child request list like
Request Response
Request Row: 4758,38475,4890 Yes, No,No
Is this possible?
hahaha, sorry I didnโt realize the formatting got screwed up when i submitted the question. Below is what I meant:
For example, letโs say thereโs three YouTube videos on a channel and I want to submit a form to my client that shows each video and then below it, a question โDo you like this videoโ and they have an enum of Yes or No.
User | Count |
---|---|
33 | |
29 | |
29 | |
20 | |
18 |