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 Row: 4758,38475,4890 Yes, No,No
Is this possible?