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
