I am trying to create a foreign key view to bring in DMRcorAct data into a customisation in CaseEntry.
I have created a UD column on HDCase called DMRCorActID_c and I populate this through a data directive on corrective action. I have set the fields “Like” property as follows:
My understanding when creating an FKV is that I should be able to create a view for any field that has a LIKE column that is searchable in a GetByID identifier.
However, when trying to create the FKV, I cannot select my custom field DMRCorActID_c .
I have done this method successfully for DMRHead data (using a custom field called DMRNum_c, which has DMRHead.DMRNum as its LIKE property) and it seemed to work fine, but I cannot understand why it won’t work for DMRCorAct table?
Is there something I am missing perhaps?