Allow User to Login with User Id and Password.
If User is new, allow Registration.

Registration has 2 record types:
MASTER RECORD: UserId, Password, Status, FirstName, LastName, NickName, City, State, Country, Post, Email, IM, Role, Date, Time.
DETAIL RECORD: UserId, Class, Type, Sequence, Status, Date, Time, Info

Link by Master to Details using UserId key.
Master Record is unique per User Id
Detail records are multiple per User Id

For Registration:
1. Create a MASTER RECORD from Registration Form.
Allow Role selection Combobox: "ADMIN", "MEMBER", "GUEST"
Allow Status selection Combobox: "Active", "Not Active", "Other"


2. Create a DETAIL RECORD with
UserId=(Master.Userid), Class="MAST", Type="New", Sequence=0, Status="A", Date=(Current Date), Time=(Current Time), Info="New Member"

For Login:
1. Check UserId and Password Against Database. Status must be "A".
2. If not valid, indicate accordingly, and allow user to try again
3. If Valid, read master record into Flash Master Record Structure "MASTER".
a. Read all matching Detail records for UserId with Status='A' into Flash Detail Record Array Structure "DETAILS". There could be multiple Detail records with Status="A" for this UserId.
b. Create a Detail record for Each Login as follows:
UserId=(Master.Userid), Class="SESSION", Type="LOGIN", Sequence=0, Status="A", Date=(Current Date), Time=(Current Time), Info="Member Login".
c. Create a Detail record for Logout when User press logout button as follows:
UserId=(Master.Userid), Class="SESSION", Type="LOGOFF", Sequence=0, Status="A", Date=(Current Date), Time=(Current Time), Info="Member Logoff".

Use Flash Data Components for CS3.
FOR ROLE="ADMIN" allow button to Display List of Users on Data Grid and Allow C, R, U, D functions. User can Select record from Data Grid to MASTER FORM with MASTER Record info and a list of all Details with Status="A". I.e. a Master/Detail Form.

FOR ROLE="MEMBER" allow button to Display only Master/Detail form showing just that User Info only with Detail Records. Allow Update on Master Only.

DATABASE; MS SQL
MIDDLEWARE: ASP.NET

Source for all code required: .FLA, ASP scripts, Database scripts, etc.