Autofill? Help! (1 Viewer)

[yahazim]

OK. I have a Form that allows a Systems Administrator to fill out the results of testing software. We are testing the software on 6 different clients, using 135 different tests, each test which can be a pass, fail, or N/A. It's important for me to find a way to AUTOFILL a subform in the Test Results form with each client/test combination sorted by Client and then Test Sequence with the ability to choose Pass, Fail or N/A (would be BEST to have a default value of PASS) -- otherwise there will be 405 mouse clicks to fill out ONE series of tests!!

Please help!

JIM

 

[Pat Hartman]

Hopefully, you already have a table where you have defined all of the individual tests you need to do for this piece of software. Write an append query that selects rows from the test definition table for this software and appends them to the test results table. The query will need a parameter that passes it the ID of the software being tested (or whatever the parent key is). Run the append query in the AfterInsert event of the mainform so that it after a new row has been added to the parent table.

 

[yahazim]

What would the setup of relationships look like between these tables?