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.
I'm looking forward hearing back from you.
Regards, Ray
