Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

please i have Many-to-many relationships in arcMap like : enter image description here

and i want to show labels in parcel using ArcMap 10 :

  • field to show is : Zoning and Name
  • -

do you have any idea how to do it ?

  • Edit

  • -

enter image description here

share|improve this question
1  
so when you label parcel PIN=4, should the label be "Sam" or "Joe" or "Sam and Joe"? –  Roland Jan 24 at 16:31
    
Can you include a graphic of how you would like to see the parcel with PIN=4 labelled, please? –  PolyGeo Jan 24 at 20:20
    
@Roland , PolyGeo Sam ,Joe –  AbdelMounaim TAOUSSI Jan 27 at 10:42

2 Answers 2

this is not possible as such

What you could do is concatenate all the field values for the related tables on one single line, then you join the new field to your table and you can use it for labelling.

Note that the data shown on your image could be aggregated in order to make one-to-many relationship, but maybe your original dataset is more complex.

share|improve this answer

based @Abdel's edit, I think the type of answer recommended by @radouxju is the key. It's kind of messy, but that's the nature of this problem (one-to-many relations resulting in lists where each row can be of a variable length).

Another alternative you may want to investigate if all you want is to display is to do something like make a map of polygon centroids, addXYCoordinates to that featureclass, transfer this XY info over to your Owner table, and then generate a new point feature class (which will replicate a polygon centroid once for each occurrence of that polygon's Own id in the table). This point featureclass might even be useful for analysis, but that's another question...

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.