need help about vb sql please urgent

efuzone's Avatar, Join Date: Jul 2009
Newbie Member
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
0
naimish's Avatar
Banned
Sorry, my mistake.

Last edited by naimish; 7Jul2009 at 11:44..
0
naimish's Avatar
Banned
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
0
efuzone's Avatar, Join Date: Jul 2009
Newbie Member
i dont have source file for visual basic soft so what should i do please
0
naimish's Avatar
Banned
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