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)
 Tables Relation (DATABASE DESIGN)

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-02-04 : 11:10:18
David writes "I have 2 tables "USUARIO" and "DATOSUSUARIO"

--> "USUARIO" have index primary key named "USUREF"

--> "DATOSUSUARIO" have index primary key named "DATREF" and another field named "DATUSER"

I want relation "DATUSER" with "USUREF"

I do it with MS SQL 7.0. but obtain this error when I run the sentence DELETE

Instrucción DELETE en conflicto con la restricción COLUMN REFERENCE 'FK_DATOSUSUARIO_USUARIO'. El conflicto ha aparecido en la base de datos 'SYC', tabla 'DATOSUSUARIO', column 'DATUSER'.
Se terminó la instrucción.

Somebody can I help me???

Thankss

David Cabrera
david.cabrera@anthillweb.com"
   

- Advertisement -