You are here: > ESRI Forums > arcgis desktop discussion forums > Thread Replies

ArcGIS Desktop Discussion Forums

ArcGIS Desktop - Geodatabases forum

Label a One-to-Many relationship   Joel Zimmerman Jun 14, 2007
Re: Label a One-to-Many relationship   Michael Knight Jun 14, 2007
Report Inappropriate Content • Top • Print • This Forum is closed for replies.    
Subject Label a One-to-Many relationship 
Author Joel Zimmerman 
Date Jun 14, 2007 
Message A polygon coverage has a 2 step relationship and join setup in a geodatabase. The polygon coverage is the property. The polygon relates to the transaction table holding the parcel to owner records (Parcel_ID in coverage is unique, the transaction table holds every instance of property and owner where a single property may have multiple owners, one to many relationship). Then the transaction table is joined to the owners table (many to one relationship). I would like to label the polygons with all owners last names from the owners table. Doing this with joins gives me only the first owner from the owners table. Can I write something in vbscript that access the related table and iterates through the related records to populate a multiline label? 
   
Report Inappropriate Content • Top • Print • This Forum is closed for replies.    
Subject Re: Label a One-to-Many relationship 
Author Michael Knight 
Date Jun 14, 2007 
Message This may be helpful:

http://edndoc.esri.com/arcobjects/9.2/CPP_VB6_VBA_VCPP_Doc/COM_Samples_Docs/Cartography/Labeling_and_Annotation/OneToManyLabels/d5daadc3-3514-4572-b8e9-8f2c7aeede07.htm 
  Michael Knight
GIS Solutions Architect
Contract Land Staff, LLC
Stafford, Texas

http://www.contractlandstaff.com