Custom tab in standard page with entity association

​@REOGIRARD 

Which data source did you set?

Hello ​@EntNadeeL 

I use the custom entity set : RecPartCommentsSet
 

I have 2 choices as you can see in the screenshot below :
 

Selecting the datasource with binding active result in no data in the commentary list I just added, I also have an error related to view / table :

I just checked in entity configuration page if I had to activate an additional view on InvPartConfigProject entity or on my custom entity RecPartComments, but list is empty for InvPartConfigProject entity, and no button “Additional view” available for my custom entity.

In my first message in this thread the datasource was not set even if I tested it, because tofuse says in his commentary in this topic that we don’t need it for the case I try to achieve :
https://community.ifs.com/distribution%2Dcrm%2Dcommerce%2D39/custom%2Dtab%2Dwith%2Da%2Dgroup%2Din%2Difs%2Dcloud%2D26750?postid=123530#post123530#post123530

I had a similar issue recently in Apps 10. After extensive testing I concluded that associations don't work when they are based on a custom reference field. I suspect this is related to the fact that in the custom table, the reference field is populated with the ObjectKey of the referenced object rather than the Object ID itself (although I’m not 100% sure - it’s just a guess really).

I found that if i create custom fields of type “Text” then the associations work fine. This work around is not ideal though, as it means we have to manually enter the value instead of using LoV to populate the field, and it becomes possible to enter invalid values. As such, I would be interested in hearing if anyone has any other workarounds / solutions to this.

• Robin

Hello ​@RobinHunter ,

Thank you for your answer. The 2 fields used for mapping are reference type, so I’m gonna try to remake those as text type and I’ll tell you if it solve my issue.
The no LoV availability is not an issue here and with a workflow I should be able to add partno and contract automatically without any user intervention which avoid any typing error from them.