INSERT INTO UserPersonalContacts (UserID, FirstName, LastName, Email, Phone1, Phone2, Company, Address, SuiteApt, City, State, Country, Zip, Gender_mf, Notes ,Birthdate) VALUES ('#form.userid#', '#Form.firstname#', '#form.lastname#', '#Form.contactemail#', '#form.phone1#', '#form.phone2#', '#form.company#', '#form.address#', '#form.suiteapt#', '#form.city#', '#form.state#', '#form.country#', '#form.zip#', '#form.gender_mf#', '#form.notes#' ,#form.birthdate#) UPDATE UserPersonalContacts SET FirstName='#form.firstname#', LastName='#form.lastname#', Email='#form.contactemail#', Phone1='#form.phone1#', Phone2='#form.phone2#', Company='#form.company#', Address='#form.address#', SuiteApt='#form.suiteapt#', City='#form.city#', State='#form.state#', Country='#form.country#', Zip='#form.zip#', Gender_mf='#form.gender_mf#', Notes='#form.notes#', Birthdate=#form.birthdate#NULL WHERE UserID=#UserID# and UserPersonalContactID=#form.usercontactid# SELECT UserPersonalContactID, FirstName, LastName, Email, Phone1, Phone2, Company, Address, SuiteApt, City, State, Country, Zip, Gender_mf, Birthdate, Notes FROM UserPersonalContacts WHERE UserId = #userid# AND UserPersonalContactID = #contactID#

AddEdit Contacts	Add Contact

First Name Last Name Email Gender checked>Fchecked>M Birthdate selected>#ListGetAt(Months,LoopVar)# selected>#LoopVar# Phone 1 Phone 2 Notes		Company Address Suite/Apt City State Zip Country