After more reading tonight I think I know the answer to my first question: Data (i.e., contents of fields) aren't really connected with the "base table", but are connected only to a single table occurance. That is why the data from the first Student table occurrence did not transfer to the second Student occurrence upon its generation.
But I'm still looking for a way to connect schools with both students and teachers. I think I need to set up a relationship between schools, students and teachers which is independent of events (by making another set of table occurrences), thus not allowing a closed loop. Joel
After still more reading, I solved this. I now understand that a table occurrence is just a window on the data through the relationships. Once I made the proper table occurrences and relationships, this worked like a charm!! Now to get some rest! Joel