AnsweredAssumed Answered

Show random records from selection

Question asked by jonas@jaktochfiskebutiken.se on Sep 4, 2016
Latest reply on Sep 4, 2016 by user19752

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?

 

Any ideas?

 

I have three tables:

 

Questions

     QuestionID

     RandomKey

     Question

     Answer

     Course

     Literature

 

Literature

     LiteratureID

     Title

 

Courses

     CourseID

     Name

Outcomes