Questionaire

[NigelShaw]

Hi Leigh

I got it all working. I replaced the I = 1 to 30 for a I = 1 to recordcount based on the selected query, set up a randomize query and collected the top 30 and looped through the recordset add each Qno to the array to store the numbers. It works a treat so I'll post back my final code

if you wouldn't mind offering a little advice on tables, that would be well received. I have currently 1 table that stores the the user, date, test type and results. I think I'd be best changing this to save the results in a separate table so the same user can take more than one test. Would I be right in my thinking?


Cheer
nige

 

[LPurvis]

Most likely yes.
It's hard to say without seeing the table itself.
Say, for example, you had for the user in your table "ASmith".
SUch a reference would not be forbidden as a foreign key.
For example you could table a users table,tblUsers, such as

UserID   UserName       UserPosition
-------  ------------   ------------
ASmith   Adrian Smith   Lead
SHarris  Steve Harris   Founder

However it would be more standard to use a surrogate primary key (autonumber) and reference that instead.
All I'm saying is that, depending upon the values you have already entered - it could be as simple as just adding a users table.
Or it might not. ;-)

Cheers