Synchronizing Tables

[maimejai]

Hi,

I'm a student learning how to use Access for my class project (Information Technology in a Global Society), and I chose to work with databases (even though, frankly, I'm technologically challenged). I've already finished making a very elementary database (tables, form, and a macro or two), but I was wondering if there's any possible way to synchronize the material in each table in such a way that changing the information in one would automatically update information in the other.

(I have one main table, and several other sub-ones with the exact same information but only parts of the main table. By this, I mean I created a main table with every student's Extended Essay topics, along with their supervisor as another field. Each supervisor oversees an essay for several students, so I created sub tables for each supervisor with the information of only their students.) What I'd like to know is if I can keep one main table with every supervisor's information and separate tables for each supervisor -- while, at the same time, having the main table update with the information that's added to the sub-tables by the supervisors.

I considered using Relationships, but after going through the threads here concerning relationship issues...I got even more confused.

Any help would be greatly appreciated.

<3, Patti

 

[llkhoutx]

Data should not be repeated in mutiple tables. Use table indicies to relate various tables. Example:

tbClasses
ClassID - index no duplicates
sSubject - text

tbStudentClasses - a junction Table
StudentID - indexed with duplicates
ClassID - indexed with duplicates

tbStudentInfo
StudentID - indexed, no duplicates
sFirstName - text
sMifddleName - text
sLastName - text
etc.

tbclasses is related to tbStudentClasses is related to tbStudentInfo. Note that only indicies area in multiple tables, indicating re;ationships and lookup information. No table has repeating info, except for indicies.