Help with data entry forms.

[jim]

First, I'm completely new to databases and Access so that would explain
it if there turns out to be an obvious solution to my questions. In any
event if you could respond like I don't know what I'm doing it would be
helpful.

I've the following tables:

StudentTable
------------
StudentID
FirstName
LastName
etc.

TestTable
--------------
TestID
TestDate
etc.

StudentTestScores
----------------------------
StudentID
TestID
Score
Proctored by

Teacher Table
------------
Teacher Name
Subject

I'd like to create a form where I can enter data into the Student table
and then enter test scores for a given StudentID (record in the
StudentTable) and a given Test ID (record in the Test Table) and who
proctored the test (record in the TeacherTable) to the corresponding
fields in the StudentTestScores table.

I can't seem to create a combo box that lets me select data from one
table and save it to another -Populate a combo box with Test ID from
the Test Table for example and save it to the Test ID in the
StudentTestScores Table. A combo box gives me the option of storing
that data only in fields that are in the table used to create the form.
I see the option of "remember this data to use later on" but I don't
have a clue how to use it.

any help would be appreciated.

Jim.

[J]

First you need relationships set up between your tables.

Second lets make them more readable:
1) Open up your StudentTestScores table in design view.
2) Go to the StudentID field
3) Go to the "Lookup" Tab
4) Choose the following:
Combo Box
Table/Query
StudentTable
1
3
No
0";0";1"

5) Switch to table view and check out the StudentID field now to
understand what you just did.
6) Repeat similar idea with TestID

7) Open up TestTable and repeat with [Proctored by]

OK! now you're set up.
Now go to Forms and choose "Create Form by Wizard". Make a form for
StudentTable, a form for TeacherTable, a form for TestTable, and a form
for
StudentTestScores.

You can now use those forms to add data. Here is the important part:
You must enter them in this order:
1) Students / Teachers tables
2) Test table
3) StudentTestScores

You can't enter students and tests at the same time. This is the right
way to do it, because once all the students are in there, you never
have to enter them again.

Hope that helps,
~J

jim wrote:

First, I'm completely new to databases and Access so that would explain
it if there turns out to be an obvious solution to my questions. In any
event if you could respond like I don't know what I'm doing it would be
helpful.

I've the following tables:

StudentTable
------------
StudentID
FirstName
LastName
etc.

TestTable
--------------
TestID
TestDate
etc.

StudentTestScores
----------------------------
StudentID
TestID
Score
Proctored by

Teacher Table
------------
Teacher Name
Subject

I'd like to create a form where I can enter data into the Student table
and then enter test scores for a given StudentID (record in the
StudentTable) and a given Test ID (record in the Test Table) and who
proctored the test (record in the TeacherTable) to the corresponding
fields in the StudentTestScores table.

I can't seem to create a combo box that lets me select data from one
table and save it to another -Populate a combo box with Test ID from
the Test Table for example and save it to the Test ID in the
StudentTestScores Table. A combo box gives me the option of storing
that data only in fields that are in the table used to create the form.
I see the option of "remember this data to use later on" but I don't
have a clue how to use it.

any help would be appreciated.

Jim.