Relationships - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Relationships

Author

Topic

FabioEinaus
Starting Member

41 Posts

Posted - 2006-12-20 : 06:27:33

Hi mate!

I getting a new problem with a relationship

I already checked the relatioship and i got the document '05' in the Documentos table but it stills returns me the error in the pic above

This is the diagram of the relationships do you see something wrong?

Thanks in advance for the replys

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2006-12-20 : 06:47:00

quote:
This is the diagram of the relationships do you see something wrong?

No, nothing wrong...just the entire diagram is missing!

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

ditch
Master Smack Fu Yak Hacker

1466 Posts

Posted - 2006-12-20 : 06:47:24

Can you script the tables from management studio and paste them here.
Documentos and DocumentosArtigos - should be sufficient.

I think that there is more to the foreign key than the diagram suggests - cos if the fk constraint name is FK_DocumentosArtigos_Documentos1 - then that would suggest that you have more than 1 constraint on that table.

Duane.

ditch
Master Smack Fu Yak Hacker

1466 Posts

Posted - 2006-12-20 : 06:50:49

>> No, nothing wrong...just the entire diagram is missing!

Huh???
I can see the entire diagram ... and us out here in Darkest africa have very, very slow internet connections.

Duane.

FabioEinaus
Starting Member

41 Posts

Posted - 2006-12-20 : 09:17:04

I solved the problem

I had a problem in the trigger that will be suposed to insert DocumentoID and CodDocumento but I had that wrong.. It was CodDocumento and DocumentoID so the foreign key doesn't match

Noob problem solved

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources