topic Automatically Select Related Records from a Query: in Data Management Questions https://community.esri.com/t5/data-management-questions/automatically-select-related-records-from-a-query/m-p/4299#M298 <HTML><HEAD></HEAD><BODY><SPAN>Hello:</SPAN><BR /><SPAN>I have a geodatabase that houses a primary table with jurisdictional plans.&nbsp; A plan may relate to multiple jurisdictional boundary types such as counties and cities.&nbsp; To address this, a second table (Jurisdictions) was designed to house all potential jurisdictional boundaires using a one (Plans) to many (Potential Jurisdictions).&nbsp; The many are simply combined records of every potential boundary using the FIPS codes.&nbsp; The unique identifier is the plan number.&nbsp; </SPAN><BR /><BR /><SPAN>To geospatially enable the data, a one to one relationshp is connected from the jurisdictional table to the census feature classes.&nbsp; A one to one for the counties, and a one to one for the communities (cities) using the FIPs as the unique identifier.&nbsp; If I write a query for the plans, subsequently wanting to select all GIS areas, I have to choose the relationship, I have to slected the related tables option three times to get my results.&nbsp; Is there a method to automate the selection of the related tables, so if I ran a query for plans, it would then automatically select the jurisdictions associated with that plan, and in turn select their geographic counter parts?</SPAN><BR /><BR /><SPAN>I would also like the relationship capability to work the other way, for instance, which plans are associated with which queried geographic entities.&nbsp; For instance:&nbsp; which plans are associated with this community AND this county.&nbsp; Because of the multiple one to one relationships, is there a way to add to selected features after the first relationship is performed?&nbsp; It over-rights the current selection each time, limiting my ability to discover how many plans are associated with two types of jurisdictional boundaries.&nbsp; Thanks for any input you may have in helping with this matter!</SPAN></BODY></HTML> Tue, 31 Jul 2012 12:39:01 GMT MarkEnglish 2012-07-31T12:39:01Z Automatically Select Related Records from a Query: https://community.esri.com/t5/data-management-questions/automatically-select-related-records-from-a-query/m-p/4299#M298 <HTML><HEAD></HEAD><BODY><SPAN>Hello:</SPAN><BR /><SPAN>I have a geodatabase that houses a primary table with jurisdictional plans.&nbsp; A plan may relate to multiple jurisdictional boundary types such as counties and cities.&nbsp; To address this, a second table (Jurisdictions) was designed to house all potential jurisdictional boundaires using a one (Plans) to many (Potential Jurisdictions).&nbsp; The many are simply combined records of every potential boundary using the FIPS codes.&nbsp; The unique identifier is the plan number.&nbsp; </SPAN><BR /><BR /><SPAN>To geospatially enable the data, a one to one relationshp is connected from the jurisdictional table to the census feature classes.&nbsp; A one to one for the counties, and a one to one for the communities (cities) using the FIPs as the unique identifier.&nbsp; If I write a query for the plans, subsequently wanting to select all GIS areas, I have to choose the relationship, I have to slected the related tables option three times to get my results.&nbsp; Is there a method to automate the selection of the related tables, so if I ran a query for plans, it would then automatically select the jurisdictions associated with that plan, and in turn select their geographic counter parts?</SPAN><BR /><BR /><SPAN>I would also like the relationship capability to work the other way, for instance, which plans are associated with which queried geographic entities.&nbsp; For instance:&nbsp; which plans are associated with this community AND this county.&nbsp; Because of the multiple one to one relationships, is there a way to add to selected features after the first relationship is performed?&nbsp; It over-rights the current selection each time, limiting my ability to discover how many plans are associated with two types of jurisdictional boundaries.&nbsp; Thanks for any input you may have in helping with this matter!</SPAN></BODY></HTML> Tue, 31 Jul 2012 12:39:01 GMT https://community.esri.com/t5/data-management-questions/automatically-select-related-records-from-a-query/m-p/4299#M298 MarkEnglish 2012-07-31T12:39:01Z