is there a way to complete records in tables automatically?

[lieufirst]

hi there,

well i have a db that is consists of 6 tables. 1 for the detailed information of students, 1 for the exams they should take another table that combine student name and class and id from information of student table with the exam code from exams table and his grade in this exam .

at the last table i choosed for the field of the name a lookup wizard that connects to student detailed information table so i dont have to type the whole name again .. Just select it from drop down list .. now i want the whole records to be generated automatically for a specific student that i had selected...

Knowing that i have set the relation between all related fileds from different tables to enforce referntiol integrety and cascade update and delete ...

Can any body Help me ...
BeSt ReGaRds

[nico5038]

Not sure what you want to generate...
I guess you want to see the entered data for the student on one form.
In such a case just make the student table the recordsource for the form and add "linked" subforms to get the data for the selected student.
Just follow the Wizard and accept the proposed linking field.

Nic;o)

[lieufirst]

Hey Nico,

the point that i am not working on a fourm am working directlly onto the table ..
so lets say it again 2 tables many to many relation so i break this relation into a third table ...
now all i want is when i enter that id of a student in this third table i dont have 2 retype his details i want them Just to apper them selves ...
consider the following
in table student : id, stud_name, stud_add, stud_telephone, stud_classroom.
in table exams: exam_code, exam_name.

in the third table(stud_exam): id, stud_name, stud_classroom (all the past records from table student), exam name (from table exam), grade, (which is the new field in this table)
so in a very simple words i want while entering the data manually into data sheet view of a table... when i type the id of a student the rest fields of this table be populated by them selves from the corresponding fields in student table...

i hope u can understand me clear now :)
Waiting a reply Soon
BeST reGards