Quiz app

[ADRN]

Hello,

I have an app, which stores courses (put on YT). 

Each course should have quiz. The users of the app should be able to 

1. Get course assigned by the Manager
2. Watch the video
3. Go through the quiz to asses the knowledge. 

I am at the phase of building quiz and I am struggling with design. 
I started to make tables: 
Courses
Quizes
Questions
Answers

With the logic: One course can have many quizzes, one quiz can have many questions etc. 


And I have problem to create a form on which I could put all that, saying:
You choose material, then choose a quiz, then choose up to 5 questions, and assign answers to all the questions. 

Either my design is false or I do not know how to use REF properly. Or both. 

Can someone help? 
There is very little materials about making quizzes or they are to simple.

Would greatly appreciate that. 

Thank you!

[dbaum]

---

@ADRN wrote:

Either my design is false

---

Nothing you described seems off track.

---

@ADRN wrote:

I do not know how to use REF

---

Try sharing concrete details--likely screenshots--of what you've configured.

If you haven't already, experiment with the Is part of property for Ref type columns.

[ADRN]

Hi @dbaum , thank you for helping with this topic. 

I already used Ref to connect tables with each other, using 1 to Many relationships. 

It worked somehow, when I wanted to connect the tables...until I get to the phase of creating form for the quiz. 
Here is data sources (App Databases only): 

 The red one are the main in regard of this quiz making app. Also the quizes are based on the video materials (links to YT to put into the app) which are stored in TB_knowledge_materials.

Tables hierarhicaly:

TB_knowledge_materials:

TB_onboarding_quizes:

TB_onboarding_questions

TB_onboarding_answers:

Relationships right now (red is the issue): 

Please let me know if you need more data or screens. 

And the questions is: 
- how to build form by which a moderator will ve able to make a quiz for a choosen material
- what should looks like the form for the users
- should participatn answers be inserted into some other table? 

[dbaum]

In your app there's likely already a system-generated form view for each of your tables. Since you have each child table's Ref column's Is part of property enabled, each parent table's generic form should already have a button for adding "New" child records. If you're creating a form view from scratch and adding columns explicitly, include the parent table's "Related..." column.

[ADRN]

Yeah, there are such fields. 
After checking the option "Show?" they appear, but after adding some records through that method, this field suddenly disappear. 

Second thing is, having all the quizez, questions and answers prepared, how Can I put it into a single quiz form? 

Should I prepare separate table just to take the answers choosen by the user??