>>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.
>
>I worked with a system to store university grades. Once a colleague wanted to automate the class scheduling, you know, avoiding some conflicts, mainly: the same teacher teaching two courses at the same time, two courses being scheduled in the same room at the same time. I kind of gave up on that, as it seemed too complicated.
I've done some stuff like that. The trick is, again, having a pivot table representing the one to many relationship. If you know a course can have more than one teacher or one teacher can be doing more than one thing in a time period you need to have a lot of these linking tables. Before views doing this stuff was so painful it almost wasnt' worth it but when VFP came out and finally got that "Ah ha" moment about the implications of using views, I actually had fun figuring out the data designs for this stuff. ( which kind of shows how dull my life had become ... < s > )
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.
