topic Re: Arcpy and Relationship Classes in Python Questions https://community.esri.com/t5/python-questions/arcpy-and-relationship-classes/m-p/538022#M42090 <HTML><HEAD></HEAD><BODY><P>Layer files are simple&nbsp; pointers to the data if they can see the data in arcmap chances are they have at least read acces to the data. <A href="http://desktop.arcgis.com/en/arcmap/10.3/analyze/arcpy-functions/layer-properties.htm" title="http://desktop.arcgis.com/en/arcmap/10.3/analyze/arcpy-functions/layer-properties.htm">Layer properties—Help | ArcGIS for Desktop</A> </P><P>Here is the help on relationship classes if you get stuck somewhere please let us know <A href="http://desktop.arcgis.com/en/arcmap/10.3/analyze/arcpy-functions/relationshipclass-properties.htm" title="http://desktop.arcgis.com/en/arcmap/10.3/analyze/arcpy-functions/relationshipclass-properties.htm">RelationshipClass properties—Help | ArcGIS for Desktop</A> </P></BODY></HTML> Mon, 18 Apr 2016 18:38:08 GMT WesMiller 2016-04-18T18:38:08Z Arcpy and Relationship Classes https://community.esri.com/t5/python-questions/arcpy-and-relationship-classes/m-p/538021#M42089 <HTML><HEAD></HEAD><BODY><P>Old Data:&nbsp; A FC of building polygons with the name of a facility we inspect.&nbsp; If the building had &gt;1 facility per building (very common) only one was included.</P><P></P><P>New Data: FC of building polygons that contain facilities and a table (non-spatial) of facilities. There is a 1-M relationship class of buildings to facilities (M facilities to 1 building).&nbsp; Facilities table contains all the information we have on the facility in our sql database.</P><P></P><P>We have a custom addin that included a facility search/zoom tool (by name) that searched the old--incomplete--data.&nbsp; Our users would like a new tool for the new data.</P><P></P><P>The Problem:&nbsp; Our users have no database connections.&nbsp; They use .lyr files.&nbsp; So if I create a geoprocessing tool or a Python Addin that querys the facilities table then related FC and zooms to the selected FC building they will need a database connection.&nbsp; Or at least I think so. </P><P></P><P>Any ideas of how to do this without connecting them to the sde? Also on a python approach for selecting the related records?</P></BODY></HTML> Mon, 18 Apr 2016 16:30:46 GMT https://community.esri.com/t5/python-questions/arcpy-and-relationship-classes/m-p/538021#M42089 BradJones 2016-04-18T16:30:46Z Re: Arcpy and Relationship Classes https://community.esri.com/t5/python-questions/arcpy-and-relationship-classes/m-p/538022#M42090 <HTML><HEAD></HEAD><BODY><P>Layer files are simple&nbsp; pointers to the data if they can see the data in arcmap chances are they have at least read acces to the data. <A href="http://desktop.arcgis.com/en/arcmap/10.3/analyze/arcpy-functions/layer-properties.htm" title="http://desktop.arcgis.com/en/arcmap/10.3/analyze/arcpy-functions/layer-properties.htm">Layer properties—Help | ArcGIS for Desktop</A> </P><P>Here is the help on relationship classes if you get stuck somewhere please let us know <A href="http://desktop.arcgis.com/en/arcmap/10.3/analyze/arcpy-functions/relationshipclass-properties.htm" title="http://desktop.arcgis.com/en/arcmap/10.3/analyze/arcpy-functions/relationshipclass-properties.htm">RelationshipClass properties—Help | ArcGIS for Desktop</A> </P></BODY></HTML> Mon, 18 Apr 2016 18:38:08 GMT https://community.esri.com/t5/python-questions/arcpy-and-relationship-classes/m-p/538022#M42090 WesMiller 2016-04-18T18:38:08Z