Hello sir, i am faizan i need your help its realy urgent, i am working in one office as a computer operator and i am nill in VB and SQL they have one software made by one person he just gave them exe file to run and setuped sql database.. now the software is showing all trial balance and ledger in records everything is ok but when i insert any new entry for cash receipt it says "Runtime error '2147217873 (80040e2f)' [Microsoft] [ODBC SQL Server]INSERT Statement Conflicted with column foreign Key constraint 'FK-GL-Account-Line-GL-Accounts' The conflict occured in DB 'Accounts_2008' table GL_Account' column 'idno' please let me know how to solve this problem. i dont have source code file for this software just i have database backup and one mdf file.. to attech database.. Thanks in advance Regards Faizan Ahmed
The error message is pretty clear. You have specified key values that doesn't exist in the parent table. The message indicates the constraint and table so you can find out which tables are involved
The only thing I can see is, either go ahead and develop new your own code, or do some R&D on database table's structure