Hi
I have the following tables
one to many relation between Header and Detail
Detail has zero or one record in Replay

The problem is because Detail has got 5 property composite key as pk i am unable to map to Graphic table which has got only 3 of the property from the composite key to map, to get the GRAPHICCODE.
And i keep getting ...must have same number of columns as the referenced primary key...
I am really struggling with how to achieve this.

Basically the output i am trying to achieve is:

ProductNumber ColorCode SizeCode GraphicCode
12345 AAA SM TTTT
12345 AAA MD TTTT
12345 BBB SM TTTT
12345 BBB MD TTTT

Header: -> PROGCD+CHCD acts as compositekey to make pk
PROGCD
CHCD

Detail:
PROGCD
CHCD
PRODCD
COLORCD
SIZECD
AMOUNT

Replay:
PROGCD
CHCD
PRODCD
COLORCD
SIZECD
PRICE
POSTAGE

Graphic:
PROGCD
CHCD
PRODCD
GRAPHICCODE

Can anyone please help me how to solve this?

Many Thanks
Ela

You can have the PK in Graphic using those 3 columns, and the have a mapping in Details which uses the same 3 columns to form a foreign key, therefore a @ManyToOne association.

Thanks for the reply.

But there could be zero records in graphic. So can't have the pk in graphic table. Only relation could be is between Header -> Detail -> Graphic