idea Add definition query to relationship class in Data Management Ideas https://community.esri.com/t5/data-management-ideas/add-definition-query-to-relationship-class/idi-p/970411 <P>When setting up a relationship class, it would be nice if a definition query or filter could be applied. For example, I have a layer of polygon that contains bituminous, concrete and gravel surfaces. I also have a table of maintenance history for the bituminous only. I have the two related and it sometime causes issues when a user adds a related record from the attribute editor or when accessing the related table some other way such as through identify.<BR /><BR />There are workarounds that can achieve the above within an MXD, but they don't mitigate a user accessing the data base directly and bringing unfiltered data.</P><!-- content transformation source ID: 087E00000004Zp3 --> Fri, 26 Aug 2022 00:04:47 GMT SimonMorgan 2022-08-26T00:04:47Z Add definition query to relationship class https://community.esri.com/t5/data-management-ideas/add-definition-query-to-relationship-class/idi-p/970411 <P>When setting up a relationship class, it would be nice if a definition query or filter could be applied. For example, I have a layer of polygon that contains bituminous, concrete and gravel surfaces. I also have a table of maintenance history for the bituminous only. I have the two related and it sometime causes issues when a user adds a related record from the attribute editor or when accessing the related table some other way such as through identify.<BR /><BR />There are workarounds that can achieve the above within an MXD, but they don't mitigate a user accessing the data base directly and bringing unfiltered data.</P><!-- content transformation source ID: 087E00000004Zp3 --> Fri, 26 Aug 2022 00:04:47 GMT https://community.esri.com/t5/data-management-ideas/add-definition-query-to-relationship-class/idi-p/970411 SimonMorgan 2022-08-26T00:04:47Z Re: Add definition query to relationship class https://community.esri.com/t5/data-management-ideas/add-definition-query-to-relationship-class/idc-p/970412#M1183 <HTML><HEAD></HEAD><BODY>Yes, that would be very useful! <!-- content transformation source ID: 00aE0000006GtCR --> </BODY></HTML> Thu, 15 May 2014 13:28:11 GMT https://community.esri.com/t5/data-management-ideas/add-definition-query-to-relationship-class/idc-p/970412#M1183 MatejTacer 2014-05-15T13:28:11Z