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

Using a single form to enter data into several Tables

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a
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.