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.
Last edited by shri411 (2016-07-28 12:19:04)
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??