By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,106 Members | 2,335 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,106 IT Pros & Developers. It's quick & easy.

is there a way to complete records in tables automatically?

P: 6
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
Mar 16 '08 #1
Share this Question
Share on Google+
2 Replies

Expert 2.5K+
P: 3,072
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.

Mar 17 '08 #2

P: 6
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
Mar 17 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.