Can you have any idea about randomly shuffle the questions in database without affecting questions id.
Let i will explain little bit more ...... read carefully
1) I have a table containing 5 questions like this
2)I am using access database, now in my application their are multiple user suppose two users 1,2
3) Now what i want when every time user has started the test he will find questions should be shuffled not on next button remember. Question shuffled on first time only.
4) But remember how to manage these things on next and previous button. For that actually i have added a one column in table which is auto number after shuffling i am fetching next que_id on the basis of that auto number but doesn't work
Hope you guys understand my problem........ so waiting for Ur's pleasant reply.