Linking two tables together

[larry]

Hi everyone..

Was hoping someone here can help me w/ my delimna:

Does anyone know how to better link two tables? I have one
table called tbl_INDIVIDUAL, it has the following field:
InterviewID, Courses, Systems, Areas, Hobbies, SchoolName,
LastName, FirstName, Email, & Tel. On the other table
called tbl_SUMMARY, it has InterviewID, ID (autonumber),
SchoolName, Courses, Systems, Areas, & Hobbies. The
tbl_SUMMARY summarizes the tbl_INDIVIDUAL by SchoolName. I
have 15 SchoolName and so tbl_SUMMARY has 15 entry in
Courses, Systems, Areas, and Hobbies. What I would like to
have happen is that when a user goes into tbl_Individual to
add a new InterviewID, it automatically just append the new
record in tbl_SUMMARY. Is this possible?

Thanks for any help on this.

Larry

 

[Roger Carlson]

What you need is to throw out this design and start over.

Instead of tbl_Individual, you probably need at least 6 tables:
tbl_Individual
tblCourses
tblSystems
tblAreas
tblHobbies
tblSchools

What's more, depending on the relationship between the individual and these
other tables, you may need 4 or 5 more tables to resolve many-to-many
relationships.

Also, I can't quite figure out what the summary table is all about, but you
never (read that rarely) need to copy data (courses, hobbies, etc) from one
table to another. Most data should be stored only once in a database.

I suggest you get a copy of Michael Hernandez's: Database Design for Mere
Mortals. When you've read that, I have some tutorials on my website that
help illustrate the process he gives. You can find them here:
http://www.rogersaccesslibrary.com/TutorialsDesign.html