I am a newbie and I have received some great expert advice, but I'm just not proficient enough to follow everything yet. I will award the remaining points that I have to anyone who can produce the code for a registration page and a confirmation page.
The points will only be awarded if they work and I can reproduce them.
You must include a connection string using Server.MapPath for a database named test.mdb
You must include a recordset object called rsTest (If other recordsets need to be produced, use numbers like rsTest2, etc.)
The registration page (Register.asp) should contain the following fields:
FirstName - textbox
LastName - textbox
EmailAddress - textbox
CourseList - listbox - Multiple selections
You should create an Access database with these fields in a table called Members:
CourseID (foreign key)(From Courses table)
There should be a second table called Courses and you should put these in it:
In the Courses table, there should be 5 items:
1 Windows Overview
The CourseList object must be populated by the database; not just listed in the listbox.
The MOST IMPORTANT thing is that when a user makes a multiple selection from the CourseList listbox, all of those selections MUST be sent to the database. And still as a single record.
Once the user completes the registration page, they should receive the confirmation page (Confirmation.asp) showing all of their information.
If any changes need to be done, then this page should also contain code to do an update.
If you can give me this, the points are yours. If you cannot meet these requirements, please do not post your code.
If you need further clarification on anything, please let me know