Pull Data from 2 tables into a different one

[tracy.cooperjr]

I have 2 tables containing data that I need to have pulled into another
table as well as extra data already in the first table.

Table 1 has data pertinent to the students class schedule
Table 2 has data pertinent to the students specific disabilities
Table 3 will pull the class schedule for a student from table 1 and the
students disabilities from table 2.

In essence table 3 will look like this

"STUDENT ID" "CLASS" "ACCOMMODATIONS" "ALLOWED"(checkbox)
....
....

All 3 tables can be linked through the student ID numbers.
How do I pull the data from the 1st 2 tables to go into the 3rd?

Any questions just email me.

 

[Guest]

you don't want to have duplicate data actually entered into table 3 (other
than the cross referencing field of the student ID)

you would bring the data together via a query ; and then base a form or
report off the query

 

[tracy.cooperjr]

What do you mean? I do not quite understand. I can see linking them
through the ID fields but what do you mean not needing to duplicate
data from table 3 into tables 1 and 2? I was trying to do it the other
way. Having data from tables 1 and 2 be pulled into table 3.

 

[Guest]

ok maybe I don't quite follow your terminology of "pulled into" table 3 - but
nonetheless the fundamental rule of database design is not to entry duplicate
info in multiple tables....that's the key.

there is no need.

In many cases one can simply bring together info from multiple tables using
a query - to present together in a Form or Report. In some other cases one
needs a 3rd table as a junction or cross reference table - whatever should be
in table 3 should only be cross references to table 1,2 - not the actual
info.... i.e.

Student Info Table
101. Name1 Address Tel
102. Name2 Address Tel


Class List Table
A. Math101
B. Spanish101

StudentsInClass Table
1. A 101
2. A 102
3. B 101
4. B 102

 

[tracy.cooperjr]

Ok. I get it. Thank you.

ok maybe I don't quite follow your terminology of "pulled into" table 3 - but
nonetheless the fundamental rule of database design is not to entry duplicate
info in multiple tables....that's the key.

there is no need.

In many cases one can simply bring together info from multiple tables using
a query - to present together in a Form or Report. In some other cases one
needs a 3rd table as a junction or cross reference table - whatever should be
in table 3 should only be cross references to table 1,2 - not the actual
info.... i.e.

Student Info Table
101. Name1 Address Tel
102. Name2 Address Tel

Class List Table
A. Math101
B. Spanish101

StudentsInClass Table
1. A 101
2. A 102
3. B 101
4. B 102