Hi m a newbie doing a project in online exams in ASP.NET & MS ACCESS I have the following table containing Questions:
QID(autono),Question,OptionA,OptionB,OptionC,OptionD

and I have one more table Tests:
TestID,QID,Question,OptionA,...OptionD,Duration

Now m showing a form where I enter the number of Questions in the test & duration.I want a random function to pick up Questions from the Questions table(random enuf not to repeat Questions) and insert them to the Tests table(TestID will be provided while creating the test).

Can sum1 help me out with both the above tasks.Its urgent pls help