title: SQL Server error: the INSERT statement conflicted with the FOREIGN KEY constraint
body: <p>I know this may sound dumb to ask but I have trouble with these tables, I know they are wrong but I don't know how to fix them. </p>
  
  <p>This is my code:</p>
  
  <pre><code>create table Empresarial
  (
      paquete varchar(10) not null,
      Alojamiento varchar(10),
      correo varchar(15),
      nlineas int,
      precio decimal(7,2),
      constraint pk_paquete_empresarial primary key(paquete)
  );
  
  create table Telefono
  (
      paquete varchar(10) not null,
      nllamadas varchar(15),
      precio decimal(7,2),
      constraint pk_paquete_telefono primary key(paquete)
  );
  
  create table TVTel
  (
      paquete varchar(10) not null,
      nllamadas varchar(15),
      canales varchar(10),
      TVS varchar(10),
      precio decimal(7,2),
      constraint pk_paquete_tvtel primary key(paquete)
  );
  
  create table TV
  (
      paquete varchar(10) not null,
      canales varchar(10),
      TVS varchar(10),
      precio decimal(7,2),
      constraint pk_paquete_tv primary key(paquete)
  );
  
  create table Paquete
  (
      IDContrato int not null,
      TipoCon varchar (11) not null,
      paquete varchar(10) not null,
      constraint pk_IDContrato primary key(IDContrato),
      constraint fk_paquete_empresarial foreign key (paquete) references Empresarial(paquete),
      constraint fk_paquete_telefono foreign key (paquete) references Telefono(paquete),
      constraint fk_paquete_tvtel foreign key (paquete) references TVTel(paquete),
      constraint fk_paquete_tv foreign key (paquete) references TV(paquete)
  );
  </code></pre>
  
  <p>Here are my Inserts:</p>
  
  <pre><code>insert into Empresarial 
  values ('EMPPAQ001', 'SI', 'SI', 50, 1499.00);
  
  insert into Telefono 
  values ('TELPAQ001', '1000', 249.00);
  
  insert into TV 
  values ('TVSPAQ001', '52', 1, 289.00);
  
  insert into TVTel 
  values ('TVTPAQ001', '1000', '52', 1, 329.00); 
  
  insert into Paquete 
  values (1001, 'Mensual', 'TVTPAQ001'), 
         (1002, 'Mensual', 'TVSPAQ001'),
         (1003, 'Mensual', 'TELPAQ001'),
         (1004, 'Mensual', 'EMPPAQ001');
  </code></pre>
  
  <p>The thing is, I want to reference 4 primary keys from 4 different tables to one column in another table as a foreign keys. I get this error:</p>
  
  <blockquote>
    <p>The INSERT statement conflicted with the FOREIGN KEY constraint "fk_paquete_empresarial". The conflict occurred in database "telecommsouthtest", table "dbo.Empresarial", column 'paquete'.</p>
  </blockquote>
  
  <p>when I do some inserts in the table <code>Paquete</code>. How can I fix it?</p>