talon wrote: > > Ok.. i made the changes to "Credit Card" but now I get this error: > > INSERT INTO MasterAccounts (active, firstname, lastname, address1,address2, city, state, zip, phonehome, phonework, phonefax, PayMethod, creditcardnumber, creditcardexpire, creditcardauth, GroupID, PayPeriod, Region, Extension, SalesPerson, LastModifyUser) VALUES(-1, 'Tim2','Blanton','43 Test','','Indpls','in','46222','317-244-3849',' ', ' ', 'Credit Card','49963612701212013','0301','Tim Blanton',1, 'Annually','Indianapolis',10, 'Internet', 'Internet' )INSERT INTO SubAccounts (CustomerID, Login, Email, FirstName,LastName, PhoneHome, PhoneWork, AccountType, Discount, Description, Password, SystemType, ModemSpeed, NetSoftware, Operator, LastModifyUser, LoginLimit, saCurrent ) VALUES(1062,'test123','test123@midlink.com','Tim2','Blanton','317-244-3849',' ', '56K','Normal Users','32mb','Fo*083','pentium','33600','MS Explorer 3.0','Internet','Internet',2,-1) > Microsoft OLE DB Provider for ODBC Drivers error '80040e14' > > [Microsoft][ODBC SQL Server Driver][SQL Server]INSERT statement conflicted with COLUMN FOREIGN KEY constraint 'FK__SubAccoun__Accou__0A489020'. The conflict occurred in database 'Emerald', table 'AccountTypes', column 'AccountType' > > /signup/signup.asp, line 1947 > > Any ideas?
Its the same type of Error. You need to modify the account list to
match YOURS. In the above the AccountType is 56K. Do yuo have a
service type of 56K?
--
Dale E. Reed Jr. Emerald and RadiusNT__________________________________________IEA Software, Inc. www.iea-software.com