[dbimen]

The two sets of code for the problem can be downloaded here....

www.newhostsite.com/amhsParents2/code


I know it needs to be cleaned up a little but, I need to get this to work first!

I am trying to have the user select the person's name on the first page and on the second page, display available time slots for an appointment.

I am not getting any response on the 2nd page when the names are selected on the first page.

The table of the people listed is tblTeachers. The table with the appointments is tblParentTeacher.

tblTeachers has a column called Item_ID which is the primary key in addition to a column called TeacherName. tblParentTeacher has numerous columns but also includes TeacherName as a column.

When the name is selected, the available appointments should show up on the 2nd page. Right now, I am getting no data, but no error. This means to me, that I am just making a mistake with the code.

The name that is selected on the first page should be the value in the TeacherName column of the record that is displayed from the tblParentTeacher table.

I hope I explained it clearly so that you are able to see if you can find the problem.

Any help is much appreciated...Let me know

[dbimen]

bump

[haswalt]

well clearly you are not getting the teacher id correctly first. I get that error when i try it.

I select a teacher name so it passes the name of the teacher to the asp script but without seeing the code i can't help more.

We need more information before we can say more.