I have created a relationship class similar to the one I posted about in this question.
Essentially, there is a point feature class representing a location of vegetation clearing with attributes about the point (size of clearance, property ID, etc). There is also a table with information about different vegetation species that were cleared at that point and attributes about the vegetation (how much of each species was cleared, count of species, etc). The two are linked together with a 1-Many relationship class based on a unique ID which I created.
I can successfully click on a point and see the information about the point as well as all the species that were cleared at that point using the information tool.
However, I would like to query the points based on attributes in the plant species table. For example, "select all points which contain a particular species". But, the Select By Attributes tool doesn't let me see fields in the table. Just the fields in the point feature class.
How can I do this? Is this a limitation of relationship classes? Do I need to query the data some other way?
Thanks for any help.
Best Answer
This works for a "relate" (definded in an MXD). I'm not sure if it works for a "relationship class". Please try.
If you work with a relate you make a selection in table A and transfer this selection to tabe B (this works in both directions of a relate):