I've made a database for registering questions and answers to help with my studies. I would like to write my own questions and answers, choose what course and what literature that is connected to the question.
I would then like to generate 10 random questions with answers from the questions I've registered in the database. Each question and aswer is one record. But here is the thing. I would first like to choose a course and then show 10 random questions from that course, not from all registered questions. How can I do this with a script?
Is there a way to have a layout with only a dropdown selection box that shows a list of courses and then get FM to show 10 random records?
I have three tables: