Hi @CKOppBox ,

I’m not quite sure whether this is possible to match the relationships with two different data types for the  primary keys or foreign keys, in which needs to be in the same data type according to the basic principals

The relationships that exist between attributes rely on the parent-child specifications that you assign to attributes. How attributes relate to one another and the types of relationships they share define the system hierarchy which is used to generate SQL. This SQL, in turn, determines the output of a njmcdirect report.

Hi @CKOppBox , 

Child relations  \ join constraints must be based on columns sharing the same data type. 

In your case I would recommend to create \ setup a custom view which takes responsibility of the casting so you can join it on the task screen accordingly. 

Cheers, 

Ruben