Is there a way to extract attributes from features that are related to other features?
My Example: I want to select a set of utility poles and a few attributes from a related streetlight feature class. The streetlights are related via a 1:M relationship class. I would like to append the selected poles to another feature class and also a few attributes from the related streetlight features (Light_type, Wattage, etc).
Can this be done? I thought of a join, but when I try this, the defined relationship class for Pole_Streetlight is not in the dropdown for "Join data based on a pre-defined relationship class" why is this?? Any help is appreciated.
I don't understand why you can't join to another feature class that is related via a relationship class? The relationship class is there. I can select a feature and use the Related Tables button from the attribute table and it selects the related feature. So why is the related feature class not presented as a choice when you use the Join command and pick "Join data based on a pre-defined relationship class"? what am I missing?
You would not be able to do a straight join because you have a 1-M relationship it would only get a single record. If you are in an enterprise geodatabase you could use the tool i mentioned earlier.
Hi Wes. Thank you for the reply.
I looked at the tool help for make query layer. I don't see how the use of the tool accomplishes a join of 2 feature classes via a relationship class.