INSERT statement conflicted with COLUMN FOREIGN KEY

[ProgrammingB52]

I am trying to insert values in a table where there is a foreign key to another table. I can't insert data into either of these tables and get the same errror....
INSERT statement conflicted with COLUMN FOREIGN KEY SAME TABLE constraint 'FK_OrgUnit_OrgUnit'. The conflict occurred in database 'Asset', table 'OrgUnit', column 'OrgUnitId'.
The statement has been terminated.
How do I insert data into these 2 tables with the foreign key constraint?

 

[aalmeida]

The FK requires that the data exists in the othr table first so u got to insert there first and then on table 'OrgUnit'.

AL Almeida
NT/DB Admin
"May all those that come behind us, find us faithfull"

 

[ProgrammingB52]

What happened was the table had a foreign key to itself so I deleted it and it worked. Thanks