469,641 Members | 1,256 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,641 developers. It's quick & easy.

Using a single form to enter data into several Tables

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!!!
Nov 12 '05 #1
1 2238
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!!!

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

By using this site, you agree to our Privacy Policy and Terms of Use.