Problem with adding a relationship SQL Server

[Raenius]

HI,

When I try to create a relationship between to tables in my database it gives the following error:

'ROUTERS' table saved successfully
'PINGS' table
- Unable to create relationship 'FK_PINGS_ROUTERS'.
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]ALTER TABLE statement conflicted with COLUMN FOREIGN KEY constraint 'FK_PINGS_ROUTERS'. The conflict occurred in database 'netsentry', table 'ROUTERS', column 'routerID'.


Strange thing is I have been able to create this relation in the past but now it does not do it anymore.

It's a basic relation with a primary key -> foreign key situation.

Can anyone please help?

- Raenius

"Free will...is an illusion"

 

[ClaireHCM]

Check in your child table with parent table for that specific column to see any value that exists in child table but not in parent table.This is mostly where the conflict from

 

[Raenius]

All tables are empty, I've made sure of that.

Any other things?

"Free will...is an illusion"