How to select related records in a definition query

[SanchezNuñez]

Good morning,

Is there a way to query the related records in a layer definition query in ArcGIS Pro or a Web Map. I some cases I want only so select records that have a specific value in a related field.

Thanks,

[Robert_LeClair]

In ArcGIS Pro, you cannot directly query a related table in a Definition Query. Definition Queries are applied at the layer level and work with the attributes of the layer itself, not its related tables. With that said, I believe you can use the Make Query Table (Data Management)—ArcGIS Pro | Documentation geoprocessing tool to create the query layer and have it stored within your ArcGIS Pro project file.

Although this is an ArcMap resource page, here are some examples of making a query table - Examples of queries with the Make Query Table tool—ArcMap | Documentation

[TanuHoque]

@SanchezNuñez 

Adding a reference to another discussion on same/similar topic. I hope if this might help

https://community.esri.com/t5/arcgis-pro-questions/arcgis-pro-definition-query-to-select-a-group-of/...

[JohnGuilfoyle]

The Select by Attributes tool allows you to query the database.
Select the dataset and view the Attributes Table.
Add a query Where:
*Field_Name*
(<, >, =, contains, ends with, begins with, contains the text, etc.)
Enter or select value

There is also a Select by Location tool that will find points near
polygons, etc.