NorthwindLogon.zip Allows an employee user to "log on"
using the Northwind Employee last name and extension as credentials. Establishes a session variable
with the EmployeeID and moves to a second page. (If a user attempts to access the second page
without logging on, he/she is sent back to the logon page.) On the second page the employee
sees a drop-down list of orders he/she is involved with. If the user selects an order
from the drop-down list, some details of that order are displayed.
LAB Make a version of pages like those above, but instead of employees, you can have
Northwind suppliers log on using the ContactName and PostalCode as credentials. Establish a session
variable with the SupplierID and move to a second page. (If a user attempts to access the second
page without logging on, send him/her back to the logon page.) On the second page display a
drop-down list with the names of the products supplied by that supplier. If the user
selects a product from the list, display a few more fields from that product's record.