>
>You just made a very good observation about where to store the grade for the class. For many years I thought of "cross-link" tables as holding just the foreign keys for the tables being linked together, plus a primary key for the cross-link record.
>
>But, when I worked on a project that was modeled with additional data in the cross-link record that related to just that intersection, the lights went on for me!<
Sure makes report cards easy. I store lots of memo field teacher comment stuff that way as well. See my reply to AS. I'm finding schools really are their own animal, given the transient nature of students and the quarter/trimester/semester issues. Kind of fun actually.
Charles Hankey
Though a good deal is too strange to be believed, nothing is too strange to have happened.
- Thomas Hardy
Half the harm that is done in this world is due to people who want to feel important. They don't mean to do harm-- but the harm does not interest them. Or they do not see it, or they justify it because they are absorbed in the endless struggle to think well of themselves.
-- T. S. Eliot
Democracy is two wolves and a sheep voting on what to have for lunch.
Liberty is a well-armed sheep contesting the vote.
- Ben Franklin
Pardon him, Theodotus. He is a barbarian, and thinks that the customs of his tribe and island are the laws of nature.
