questionnaire for multiple users (1 Viewer)

[aliasquark]

Hi, I am trying to construct a questionnaire that asks a series of questions (one at a time) to multiple users who have to answer A or B. The users will be performing the questionnaire at the same time.
___________________

I want the questionnaire to run as follows:

1) People select their name in a form (Form1)

2) A series of questions (from the tblQuestion table) are presented to the user (Form2)

3) A table is populated which records the following info
* Response_ID (Autonumber)
* User_ID -> based on their selection in form 1
* Question_ID (number) -> taken from the tblQuestion table
* Response_Value) (Text = A or B) -> as submitted by user
___________________

I presume I need to set up the following tables:
Table 1 - tblUser
* User_ID (number)
* User_Name (Text)

Table 2 - tblQuestion - the table that contains the actual questions
* Question_ID (Number)
* Question_Description (Text)

Table 3 - tblResponse - the table that gets populated
* Response_ID (Autonumber)
* Question_ID (number)
* Response_Value (text)
___________________

My problem is that I am not used to adding records to a table (via forms) as this is the first time I have to run the questionnaire for multiple users (previously i just placed the "A or B" textfield in the tblQuestion, but this is not possible with +100 users.

Could someone please give me some advise as to how to get started with this, in particular at the Form level.

Thanks in advance, Steve