foreign key restraint error

[jimny]

i am getting an error on an insert and when I look at the table I can't find (where) this restraint lives or how to get arouond it.
Here is the 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_Members_BusinessCodes'. The conflict occurred in database 'WCAMEM', table 'BusinessCodes', column 'BusinessNum'.

/WCAMEM/modify/add_mod_process.asp, line 45

Any ideas??

 

[jimny]

never mind, found it in database diagram properties!

 

[SQLSister]

Whatever you do, don't remove the foreign key constraint! It is there for a reason to maintain database integrity!