1 2 Previous Next 15 Replies Latest reply on Sep 4, 2016 10:50 PM by user19752

    Show random records from selection

    jonas@jaktochfiskebutiken.se

      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

        1 2 Previous Next