Ndtyjky

Help please, I'm always getting this message:

There are no primary or candidate keys in the referenced table 'factIngresosCurso' that match the referencing column list in the foreign key 'fk_ingresos_curso'.

My tables:

create table factIngresos

(

    cicCod char(6),

    curcod char(5) references dimCurso,

    cursec char(2),

    codSec char(1) references dimSeccion,

    tiempoid int references dimTiempo,

    codHor int references dimHorario,

    proCodUno char(5) references dimPersonal,

    vacantes int,

    inscritos int,

    ingresoProyectado money,

    ingresoNeto money,

    becas money default 0,

    constraint pk_Ingresos primary key(cicCod, curCod, curSec) 

)

go



create table factIngCursoAlumno

(

    alucod char(8) references dimAlumno,

    cursec char(2), ciccod char(6), curcod char(5),

    alucurCosto float, alucurefe float,

    alucurPF float,

    constraint pk_facIC primary key(alucod, cursec, ciccod, curcod),

    constraint fk_ingresos_curso 

        foreign key(cursec, ciccod, curcod) references factIngresos(cursec, ciccod, curcod)

)

go

The primary key in factIngresos is

cicCod, curCod, curSec

Yet in your other table, you reference it using these columns and sequence:

foreign key(cursec, ciccod, curcod)

As you can see, just guessing from the names of the columns, the ordering is not the same as in the primary key specification.

You need to ensure that the column and their ordering (!!) is identical - so my guess is, you would need to use this foreign key configuration instead:

constraint fk_ingresos_curso 

    foreign key(ciccod, curcod, cursec) references factIngresos(ciccod, curcod, cursec)