Relationship Class Question

Question

Hi, I created a relationship class between a feature class and a table. When I open the attribute tables, I can select a record from the feature class and then see the associated records from the other table (1 to many, in this case).

My question is, is it possible to run a query on this relationship class and create a new table based on that new query?

Thanks.

WilliamCraft · Answer

Exporting from one does not imply that you would or should get records from the other.  Just because they're related via relationship class doesn't mean anything when you're talking about exporting selected records.  The exports for selected records have to be done separately no matter how you make your selection.  So, exporting feature class records to a new feature class would not mean that you could automatically get the related records from the table... and vice versa.  It's just the way the software is designed.  The fact that the relationship class is set up as 1-M (one to many) has nothing to do with this.  The only exception to this rule is in the case of a Copy/Paste from within ArcCatalog... but in that case you're dealing with the entire recordsets rather than a selection set from each.

JasonGonzalez · Answer

When I do the export, depending on which table I have open, I only get the records from that one table. I never get an export with the user info and the related data from the table.

I should say that the relationship does work, I can manually select a record from users feature class and then click the Related Tables icon and see the associated records.

Its just that the export doesn't have data from both. And really, I don't see how it could create a new table since, for example, if I select one user, he may have 20 entries from the table.

WilliamCraft · Answer

but its not allowing me to export data from both. If I do as you suggested, I can only export from one table.

I'm not sure that I understand the problem you're having.  The selected records from the feature class can also be exported in the same fashion as described with the related table.  So, you query the feature class, then export the selected features into a new feature class, then walk through the steps I described above in order to produce the new table from the selected related records.