G
Guest
I have a simple question: I have two tables, a student table and an
assignment table. The tables have been related through a one-to-many
relationship using the primary key called "student code". In addition, I have
created a form to enter student data and one to enter assignment data. It
seems to me that once I enter the student data, including the student code,
into the student table, this information should also appear in the assignment
table. Surely I do not have to enter the student code x number of times for
every assignment that is given to the student. Is there some setting that I
have overlooked that copies data to all related tables with the same field?
Second, do I have to have data entered before I run a query?
Any help would be greatly appreciated as I am completely frustrated.
assignment table. The tables have been related through a one-to-many
relationship using the primary key called "student code". In addition, I have
created a form to enter student data and one to enter assignment data. It
seems to me that once I enter the student data, including the student code,
into the student table, this information should also appear in the assignment
table. Surely I do not have to enter the student code x number of times for
every assignment that is given to the student. Is there some setting that I
have overlooked that copies data to all related tables with the same field?
Second, do I have to have data entered before I run a query?
Any help would be greatly appreciated as I am completely frustrated.