Your problem starts with an incorrect design of the tables! Consider changing
to:
TblStudent
StudentID
FirstName
SurName
<All other fields about the student you need>
TblSemester
SemesterID
<All other fields about the semesteryou need>
TblSubjects
SubjectID
SemesterID
Title
<All other fields about the subject you need>
TblGrades
GradeID
StudentID
SubjectID
Grade
You can then build your forms one of two ways:
If you want to call up a student and enter his grades in all subjects, create a
main form based on TblStudent and a subform based on TblGrades.
If you want to call up a subject and enter grades for all students taking that
subject, create a main form based on TblSubject and a subform based on
TblGrades.
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com www.pcdatasheet.com
"jbroome" <jb*****@ntlworld.com> wrote in message
news:c9*************************@posting.google.co m...
I have several tables that contain the same information as Identifying
records but then with additional info that differs from table to
table.
e.g. 1 database of school students with their relevent info
Another dbase with subject info and grades etc assigned to the
students info
I wish to use one form to enter data into all tables. The differing
infos not a problem but I am unable to input Firstname and Surname
into all tables from one form input.
Help!!!