First off, this is my first time here... I know only enough to be dangerous.
I am using the following: MS SQL DB, IIS 2000, and Dreamweaver. I have developed a student management system using asp pages and dynamic interaction with various tables in SQL.
Here is my problem:
I have a table with students stuff...
I have a table with classes stuff....
I have related them so I can add students to classes.... whoppee they work.
What I can do to this point is:
Search and dring up a dynamic list of students that are registered to that class. What I want to do is take that list, and add some fields from another table called Attendance - fields date and code".
I then want the user to just click on type of absence (code field) and then click submit - which submits all records as an insert into the attendance table. Multiple rows etc.
They are not pulling any data from the attendance table since there is no information to pull from. I cannot related the student ID's because these students are in 8 periods per day and attendance is taken during each period.
I know this can be done and I have played with a few tutorials and still no luck. I have read many articles here in the forum trying to get a handle on what I must do. I think it sounds like an array, since I don't know for any given class the total number of students(records per class) it will vary. I do know I need the list to come up, with a coupld of input fields, and then insert those into the new table.
Any and all advice would be most appreciated. I have not yet played much with asp.net but am most willing since I do have the capability and am ready for asp.net pages or asp pages for that matter. The rest are in asp.
Also, this is very critical and I am under a tight deadline for school start in one week. I would assign a million points if I could "smile"
I will send table layouts and drawings of what I need if it would help. Thank you Thank you for anyone willing to help me.
