topic Re: Selecting related tables in ModelBuilder or Python in Geoprocessing Questions https://community.esri.com/t5/geoprocessing-questions/selecting-related-tables-in-modelbuilder-or-python/m-p/449471#M15128 <HTML><HEAD></HEAD><BODY><SPAN>Hi Stephan</SPAN><BR /><BR /><SPAN>You are going to have to use a ModelBuilder tool called "Calculate Value" and write an ArcPy expression using a Search Cursor:</SPAN><BR /><BR /><A href="http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//0017000000v8000000">Calculate Value</A><BR /><A href="http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//000v00000039000000">Search Cursor</A><BR /><BR /><SPAN>Hope this gets you going <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></SPAN><BR /><BR /><SPAN>Regards</SPAN></BODY></HTML> Thu, 27 Sep 2012 18:54:37 GMT PeterWilson 2012-09-27T18:54:37Z Selecting related tables in ModelBuilder or Python https://community.esri.com/t5/geoprocessing-questions/selecting-related-tables-in-modelbuilder-or-python/m-p/449470#M15127 <HTML><HEAD></HEAD><BODY><SPAN>If I have a feature class and a table in a geodatabase, and there is a relate between them, I can very easily select a bunch of features in the feature layer in ArcMap and use the Related Tables pulldown in the table attribute window to select only those features in the table that relate to the selected features in the feature class.&nbsp; That's basic GIS 101, right?&nbsp; </SPAN><BR /><BR /><SPAN>What I am having trouble finding is a way to do the same thing, but using ArcToolbox/ModelBuilder or Python instead, so that I could include such queries in scheduled tasks.&nbsp; I have searched the help documentation and looked up in the various forums, but haven't found anything promising.&nbsp; Has anyone any suggestions?&nbsp; Thanks.</SPAN><BR /><BR /><SPAN>Stephen</SPAN></BODY></HTML> Mon, 24 Sep 2012 20:50:45 GMT https://community.esri.com/t5/geoprocessing-questions/selecting-related-tables-in-modelbuilder-or-python/m-p/449470#M15127 StephenRhone 2012-09-24T20:50:45Z Re: Selecting related tables in ModelBuilder or Python https://community.esri.com/t5/geoprocessing-questions/selecting-related-tables-in-modelbuilder-or-python/m-p/449471#M15128 <HTML><HEAD></HEAD><BODY><SPAN>Hi Stephan</SPAN><BR /><BR /><SPAN>You are going to have to use a ModelBuilder tool called "Calculate Value" and write an ArcPy expression using a Search Cursor:</SPAN><BR /><BR /><A href="http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//0017000000v8000000">Calculate Value</A><BR /><A href="http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//000v00000039000000">Search Cursor</A><BR /><BR /><SPAN>Hope this gets you going <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></SPAN><BR /><BR /><SPAN>Regards</SPAN></BODY></HTML> Thu, 27 Sep 2012 18:54:37 GMT https://community.esri.com/t5/geoprocessing-questions/selecting-related-tables-in-modelbuilder-or-python/m-p/449471#M15128 PeterWilson 2012-09-27T18:54:37Z