Diagram Shows Relationship Briefly, but it then Disappears

[Mike555]

As the subject says, I have a database with a diagram of 2 tables containing a relationship. I created this 2 days ago and it was working fine. Now when I open the diagram, the little line representing the relationship appears between the 2 tables for about 3 seconds, and then disappears. When I attempt to recreate the relationship, I get the error message:


'tblLogs' table saved successfully
'tblBundles' table
- Unable to create relationship 'FK_tblBundles_tblLogs'.
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]ALTER TABLE statement conflicted with COLUMN FOREIGN KEY constraint 'FK_tblBundles_tblLogs'. The conflict occurred in database 'sjerp', table 'tblLogs', column 'FlitchNum'.


What exactly is happening and what can be done to fix this? Please let me know if any more information is needed.

Thanks.

--
Mike

 

[mrdenny]

Sounds like your constraint has become corrupt. I would go into table design and delete the constraint and recreate it.

Denny

--Anything is possible. All it takes is a little research. (Me)

 

[Mike555]

mrdenny,

I realized that if the relationship is recreated without the option: "Check existing data on creation" the relationship could be created. I've recreated the relationship this way, and now everything is working again.

--
Mike

 

[mrdenny]

exelcent.

Denny

--Anything is possible. All it takes is a little research. (Me)