You may want to check out the "Solid Embedded Engine" from Solid Information
Technology. More info can be obtained at www.solidtech.com.
"in too deep" <fieury_at_hotmail.com> wrote in message
news:4UUn6.6591$Ok4.923681_at_news1.rdc1.ct.home.com...
> I'm building a site that will hold about 1000 lesson plans for teachers.
In
> each lesson plan there is a list of "partners" (companies that will
sponsor
> job shadowing) from a posible list of 100 or more.
>
> Here are my problems: Each lesson plan may belong to zero or more academic
> subjects (but must be tailored to that subject) and each partner may
belong
> to zero or more lesson plans (depending on the subject).
>
> e.g.:
>
> science
> science lesson plan 1
> partner 1
> partner 2
> science lesson plan 2
> partner 2
> partner 3
>
> math
> math lesson plan 1
> partner 1
> partner 3
> math lesson plan 2
> partner 3
> partner 4
>
> The only way I can see to build the database is with many-to-many
> relationships, but I fear that will make it much more difficult to code
(in
> .asp). Any thoughts would be highly appreciated. Don't hesitate to let me
> know I'm an idot - you won't be the first.
>
>
>
Received on Sun Apr 15 2001 - 21:01:58 CDT