I'm working on a web application to update a tutoring database and thought MVC would make a good framework. I've done a lot of the basic coding off of one table in the database. However, the application actually needs to pull data from multiple tables in different places and then write all of the entered data into the one table which is currently being referenced.

e.g. The table referenced by create and edit is called Encounter. It has one to many links to a Student table, a Teacher table, a School table and a Subject table. The hope is to use Ajax to call to a field in the Student table to start giving options when the name starts to be entered as well as populate a drop down list from the School table. Also looking to include a nice date and time picker for the start and finish times which can then calculate elapsed time in minutes and hours in separate fields. (Don't ask on that one, user requested.)

However to get this all started, I need to know if it's possible to access multiple tables and if there are any resources to help me catch up on how to do this so I can read and then trial and error code it myself.

Any direction to resources I'm missing will be helpful,

Thanks,

Tony

The NerdDinner application demonstrates how to build an ASP.NET MVC project starting with File -> New Project, and then incrementally adding new functionality and features. It uses ASP.NET MVC along with jQuery, ASP.NET Ajax, Virtual Earth Javascript controls, and LINQ to SQL. It’s also a real site running at NerdDinner.com that you can use to schedule geek meet-ups and nerd dinners in your neighborhood.

            http://aspnetmvcbook.s3.amazonaws.com/aspnetmvc-nerdinner_v1.pdf

http://nerddinnerbook.s3.amazonaws.com/Part2.htm
http://nerddinnerbook.s3.amazonaws.com/Part3.htm
http://nerddinnerbook.s3.amazonaws.com/Part4.htm

I think it will benefit you to work through the above
and/or other tutorials at http://www.asp.net/mvc/learn
        Learn ASP.NET MVC

Regards,
Gerry (Lowry)

I've been working on an application within the school domain. I can probably help you since I've already got a lot of something similar already being built. (my app's already got district, school, faculty tables, etc. ) send me a private message if you'd like to swap some code.