I have a DB of students and another with their test_results, I have another
Db (test_questions) with the test's questions and value. How can I populate
the test_results db with the code of the student plus all the questions in
test_questions?
Do you have multiple *databases* = mdb files containing multiple
tables, forms, reports, etc.? Or multiple *tables* in a database?
If (as I guess) these are tables then the answer is...
You don't.
You're using a relational database. Use it relationally! Relational
databases use the "Grandmother's Pantry Principle": "A place - ONE
place! - for everything, everything in its place". Student information
should be stored in the Students table, and *only* there; questions
should be stored in the Questions table, and noplace else. Your
Test_results table should have only *links* - foreign keys - to the
Student and Questions table.
You might want to look and Duane Hookum's excellent At Your Survey
sample database:
http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='At Your Survey 2000'
John W. Vinson[MVP]
