Message-ID: <003a01c04b44$f6022950$12a46e3f@workstation2> From: "Charles Myslinsky \(WCG Programmer\)" <firstname.lastname@example.org> Subject: [Emerald] Adding to MasterAccounts via. the Web Date: Fri, 10 Nov 2000 13:35:12 -0500
I am writing a script that will allow our employee's to add users to our emerald database without having to go through the software, however, upon "submitting" information from a form we are getting the following error:
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__MasterAcc__Regio__3587F3E0'. The conflict occurred in database 'Emerald', table 'Regions', column 'Region'.
/submit.asp, line 78
We are logging into the database correctly, and we can add and remove data (via. our other scripts) -- however when we try to 'Insert' data into the MasterAccounts table we are getting this error.
Any help appreciated.