SELECT ID FROM logins WHERE LoginCode = '#Form.LoginCode#' INSERT INTO logins (ID, LastName, FirstName, LoginCode, Password, AccessLevel) VALUES ('#LoginID#', '#Form.LastName#', '#Form.FirstName#', '#Form.LoginCode#', '#Form.Password#', '#UCase(Form.AccessLevel)#') INSERT INTO agents (ID, LoginID, CompanyName, FirstName, LastName, PhoneNumber, FaxPhone, URL, ReferingAgentID, Addr1, Addr2, Addr3, Addr4, Addr5, Email, UnitsAllocated, UnitsPurchased, UnitsRemaining, FreeUnitsAllocated, FreeUnitsAwarded, FreeUnitsRemaining, DateCreated) VALUES ('#CreateUUID()#', '#LoginID#', '#Form.CompanyName#', '#Form.FirstName#', '#Form.LastName#', '#Form.PhoneNumber#', '#Form.FaxPhone#', '#Form.URL#', '#Form.ReferingAgentID#', '#Form.Addr1#', '#Form.Addr2#', '#Form.Addr3#', '#Form.Addr4#', '#Form.Addr5#', '#Form.Email#', 0, 0, 0, 0, #Form.FreeUnitsAwarded#, #Form.FreeUnitsAwarded#, #CreateODBCDate(Now())#) SELECT ID, FirstName, LastName, CompanyName FROM agents ORDER BY LastName, FirstName ICS-CONNECT ADMINISTRATION - Create An Agent



#ErrMsg#
Create an Agent
Company Name:
Agent's First Name:
Agent's Last Name:
Login Code:
Password:
Agent Type: checked onClick="InFix();">Inhouse     checked onClick="OutFix();">Outside
E-mail Address:
Phone Number:
Fax Number:
Address 1:
(Street address)
Address 2:
(Suite or Unit)
Address 3:
(City, ST Zip)
Address 4:
(Country)
Address 5:
(Usually blank in USA)
Your Website:
(Include http://)
Refering Agent:
(If any)
Promotional Units:
Fields in red are required and those in gray are optional.

When finished, click on the Submit button.