Associations not recognized by Qlik for a Mendix database
Hi all,
I'm having trouble creating associations between tables that are created within a Mendix application.
Mendix is a software-platform to build applications which uses a PostgreSQL database. Moreover, associations are always stored in a separate table as follows:
Table A:
ID
CustomerName
111
Albert
222
Jane
333
Ruby
Association table:
CustomerName.ID
OrderNumber.ID
111
555
222
444
333
666
Table B:
ID
OrderNumber
444
P57
555
K13
666
H192
A record in Table A can be associated with multiple records in Table B A record in Table B can be associated with only one record in Table A Hence, this is a classic 1-to-many relation.
Now my problem: When I try to associate Table A and/or Table B with the 'Association table' Qlik classifies this association with a red color and the tables are not associated properly. Is there a logical explanation for this behaviour?
I expect that Qlik classifies this association with a green color since it should be able to match 100,00% of all records.
