integrity constraint???

[noel]

hi there

i need some help!!!

ive created a database for a company.
all the tables created fine in sql.

but the problem comes when i INSERT the employee details. i have ten employees.
6 load ok but the fifth on causes a problem. ie employee 1.....employee 4 and employee 6 all work ok but the others dont.

i get an error message stating:

integrity constraint(DSA31.SYS_C00325577)
violated -
parent key not found


anyone got any idea how to solve this??

thanks
noel.

[sjimmo]

It would appear that you have a foreign key in this table which refers to a parent table. The information is missing in the parent table.

Check your table which contains the parent record and ensure that there is a corresponding record there.