Problems on updating values

[tytlwkltc]

There is a sample database below.
I want to input the details of the new students to the student database.
A form is set and i want that after i choose a student number, the three subjects will update automatically so that i just need to input the name and teacher in charge of the student.

 

[Uncle Gizmo]

The problem is the fundamental design.

See this thread for more info:-
http://www.access-programmers.co.uk/forums/showthread.php?p=671226

 

[tytlwkltc]

Sorry that i can't design the fundamental table because they are assigned by others.

 

[GinaWhipp]

Umm, not sure I understand... that database will not work without jumping thru a lot of hoops and even then you're going to end up with a mess. What happens if you want to add more Subjects? You don't even have a list of Teachers.

That said, I guess you could write an UPDATE query to get it into the other Table. But just know you are setting yourself for trobules if you insist on using those tables.