So basically, I'm making a school test grading system as a project. Everything works fine except one thing: one of my forms is a "Results" form, where test results for each student is stored. I'm trying to make a combo box instead of simply inserting the field "TestName" so that you can select tests from a list instead of typing it in.
I already have a TestTable with all the test names and unique Test Numbers, and it is linked to the results table already. When I make the combo box with the wizard, I say to look in the TestTable for the TestName. It is all fine up to here. When I try to test it and choose a value from the list, ALL the records underneath it (test data) have a Test Name of what I just chose. How do I make these independent?
If it helps, the form itself contains Student details while a subform contains all the information for the tests.
If you need any more information that I may have missed out, please do tell me.