Talend MDM Primary Key configurations

[Anonymous]

Hi Everyone.  I have a requirement to have a combination of two fields as a primary key and that was achieved by selecting the "add key fields" option from the entity.
The other requirement is I need to set up the same key as foreign key to another field in another table.
Is it possible??
In the Screenshot attached I need the SrcSysId field also to be a foreign key to another table so that I can use the drop down options of the foreign key to select the values.
Please Respond if anyone has idea on this.

[Anonymous]

do you need the SrcSysId  to filter the dropdown SorceDescription?

[Anonymous]

Yes.The requirement is to have a single field as both UK and foreign key(SrcSysId), And It should have the option to select from the drop down like how a foreign key has.

[Anonymous]

I dont think you really need a composite key.. have you looked at the foreign key filter?
this will translated in something like select SorceDescription from table where SrcSysId=yourfield

[Anonymous]

Correct.For population of SourceDescription ,I have done that ..But the requirement is to have a composite key with SrcSysId as one of the fields with another field and that SrcSysId must show all the values in drop down like how a foreign key shows.In other words ,It has to be set as both primary key and foreign key.Am I clear with my question??

[Anonymous]

Hi ,Any Update on this??? Can we have a same field as both primary key and foreign key??