I created a dummy dataset as follows: a mapinfo table with single point ID 1, and an excel spreadsheet with 2 columns (ID and value) with ID 1 for all records and values 1 to 6. When I joined the two the info tool would only show one of the values for the selection table regardless of which record I advanced to.
When I saved and reopened the table i was able to see each individual record in the info tool.
I think that MapInfo uses its own internal unique identifier (rowid) to distinguish which record you are viewing in the info tool, and there is only one rowid for the mappable table.
Interestingly enough you can use the info tool on the selection table browser, and it will show the individual values.
So the question is, can't you just save the result of your selection and the reopen the saved table?
Regards
Stuart Morrison
From: "Nick Hall" <[EMAIL PROTECTED]> Reply-To: <[EMAIL PROTECTED]> To: "MapInfo-L" <[email protected]> Subject: MI-L mapping joins Date: Wed, 30 Mar 2005 15:06:13 +0100
Hi All,
Bit long and complicated this one but any help gratefully received.
I have two tables Polygons and Data. Polygons is a MI table but Data is an excel spreadsheet.
They share a common field ID. Data contains multiple instances of the ID field in the polygons table ID is unique.
When I join these tables using polygons.ID=Data.ID I get, as expected, a browser showing a record for each entry in the excel file.
When I map this layer I can click on a polygon and it tells me that there is
for instance 15 objects in 1 table (i.e. 15 records in excel had the same ID
number).
However, if I then click on the info tool window the data displayed for each
of the 15 records is the same - i.e. it picks one of the rows from excel and
shows that 15 times!!!! If you save a copy of the query then the info is
correct (15 different rows of data).
Can someone tell me A) why this is happening? and B) how to get MI to display the 15 different records through the info tool window?
Thanks
Nick Hall tel: 0161 278 2442
mail: [EMAIL PROTECTED] web: www.salford-gis.co.uk
-- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.8.6 - Release Date: 30/03/2005
--------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 15869
