Good day,
I have these following types of entities:
- Checklist group: a group of questions. one to many relationship between checklist group and question. many to many relationship to assessments
- Question: organized by checklist groups. one answer per question per assessment
- Answer: many to many relationship with assessment
- Assessment: set of questions to respond (checklist group). many to many relationships with checklist group. once all checklists haven responded assessment is completed.
I created this relationships, the problem is when i try to add a response, the assessment will not come across. there is a disconnect between the assessment assigned to the checklist group and the assessment for the response.
Can you help me to solve this?
Thanks,