Dear list,
A join between a MI table and a RDBMS table with one-to-many relations makes
the info tool present several records with the same data.
The solution to this is saving the join as a new table and opening this
table(!) as suggested by Simon O'Keefe and Steve Smith.
This must be a bug!
Dear list,
When I make a SQL join like:
SELECT *
FROM MI_table, RDBMS_table
WHERE MI_table.id = RDBMS_table.id
INTO new_table
and add new_table to the map, I sometimes get odd results with the Info
Tool. This behaviour occurs when the RDBMS_table contains two records with
the same id (e.g.
Soren,
I have experienced/discovered this too in the past, and have reported it
to MapInfo, they say it is due to the way that MI handles one to many
relations (sorry cant find the correspondence), but I think its just a
bug in the info tool!! or at least a design feature they need to sort
out.
Hi Søren,
I have experienced this problem too. As mad as I am that this bug has
existed for so long, I have just accepted it and used a work-around.
Save the new_table, then open it. The correct relationships will be
restored.
Cheers,
Simon