backwards relationship query

Discussion created by dbecker88 on Aug 14, 2012
currently have the following relationships:

...| [point_to_mainTable] one point - many mainTable
.........| [mainTable_to_subTable] one mainTable - many subTable

user clicks point and the 2 queryRelatedFeatures methods are ran, one for each related table. The records are post-processed and displayed in popup; all is well.

How would I allow a user to search subTable or mainTable, in order to locate points?

I could use a find task on the mainTable, grab matching records and graphic highlight joined points, but the subTable is trickier since it isn't immediately joined to points.

any advice?