I am trying to design a Access database that can choose random questions from a table and randomly place the answers in no particular order.
Questions Answers Category Section
--------- ------- -------- -------
Q_ID A_ID C_ID S_ID
Q_Ctgy A_QNo C_Name S_NumQs
Note: Q_Ctgy links up with C_ID,
A_QNo links up with Q_ID.
Q_Section links up with S_ID.
For example, I have 4 sections. In each section (S_ID), a number of questions that are selected at random for each section (S_NumQs).
These questions must be random as per each section.
Each of the answers to each question must be at random also.
Is there a way to select random questions from the table and randomly place answers within the form?