Dear listers, Another label question - my apologies if this has been covered lately. I have two tables, one of which called STATION contains graphic point locations and attribute data. The second table, SUBSTAT contains strictly non-spatial attribute data but can be joined back to the STATION table (which I have done). There is a one to many relationship between STATION and SUBSTAT. My goal is to be able to label the point locations in the STATION table with data from one of the columns in SUBSTAT. I attempted to do this by adding the query table resulting from a join between the 2 tables to a mapper. I then labelled the query table with a column originating from SUBSTAT using the layer control dialogue. This will work for a join query where the relationship between STATION and SUBSTAT is either: 1) one to one or 2)possibly many to one (have not checked) but not 3)one to many Labelling from the layer control dialogue (and choosing a column originating from SUBSTAT) will generate only one label even where there is more than one SUBSTAT record joined to a given STATION record/pt. I was half expecting to get one label for each joined record from SUBSTAT (with the labels overlapping each other) but the label control seems to display only one label where there are multiple joined records. I could make the SUBSTAT table mappable and create point locations for all its records but this would be repetitive (it duplicates the point locations in the STATION table to which its related). Also, I have several other tables which have a many to one relationship with the STATION table and would also like to label the STATION points with columns from these non-spatial tables (making them all mappable would be very inefficient). Does anyone know of another approach I could take or perhaps know some routines or software that could do the trick. Ideally it would be really nice if I could find something that will perform this task and arrange the labels to avoid overlap or better yet the ability to combine all the labels at a given STATION point into one label (with one or more characters separating each original label - eg. a return) Thanks in advance Chris --------------------------------------------------------------------- Chris Halchuk Cameco Gold Inc. Sudbury Ontario ph (705) 523-4555 fx (705) 523-4571 [EMAIL PROTECTED] ---------------------------------------------------------------------- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
