Data Entry Form Help

Hi All,

I have a data entry form that will need to place data in two tables.  The majority of the form will be placed in one table, but I have a set of 5 fields that will need to be in another table because they are related, but independent from the other data (since I want to have an unlimited number of responses in that second table per test_id in the first).  

It is similar to a database to track a test...here is the analogy to explain the data structure I have.  Suggestions are more than welcome.

The first table contains the test takers name, date, and grades on several parts of the test.  Then another table exists that will contain individual data on particular parts of the tests.  So there is a primary key on the main table that is like the test_id, and that relates to the second table to the test_id (foreign key).  The second table contains 5 fields, such as task, error_type, response, etc.  There can be an unlimited number of responses in the second table that all correspond to the same test_id.

Anyway, what I have done is made a data entry form with table_one as the data source.  The majority of information will go directly into table_one as it is entered, with data bound fields.  Then I will have 5 unbound fields that I want to populate table_two, with a submit button to add more than one set of results.

So, for instance, if a student screwed up 5 things on the test, the data entry person would enter one of the mistakes, click submit, then the other, and so on until all had been entered.  The data will be appended to table_two upon each click of the submit button, and the fields will go back to null after the data is submitted.

The end result will be table_one with a test in there, including name, etc.  Then table_two will have the test_id, and perhaps 10 mistakes attached to that same test_id.

I am very proficient in VBScript, so I just need a nudge in the right direction.  I can make all of that happen with my current knowledge, but I want to make it work well, which is why I'm here.

Any suggestions on data structure or submit methods are more than welcome.

Thank you,

GStart Free Trial