topic Is relating tables the right solution? in ArcGIS Pro Questions https://community.esri.com/t5/arcgis-pro-questions/is-relating-tables-the-right-solution/m-p/97797#M3981 <HTML><HEAD></HEAD><BODY><P>I am trying to analyze commute patterns using LODES data from the US Census. I downloaded a table that contained fields for home_census_block, work_census_block, and num_of_jobs. I joined that table to the census block geography using home_census_block as my join field. I then made a selection of census blocks that I wanted to analyze as the starting location for the commutes and made a new layer from that selection. I then created a relationship between the census block geography layer and the census block selection. The parameters for the Add Relate tool are:</P><P></P><P>Layer Name: census_block_geography</P><P>Input Relate Field: census_block_geography.GEOID10</P><P>Relate Table: census_block_selection</P><P>Output Relate Field: work_censusblockID</P><P>Cardinality: One to many&nbsp;</P><P></P><P>The Add Relate tool runs fine with no errors but I can't seem to get what I want. What I'm trying to see is what census blocks people are working in that live in the selected area. I have tried using the 'select related records' from the attribute table menu but nothing happens. I'm wondering if this is the right approach or is there something different I should be doing to get the desired results. Any guidance would be much appreciated.</P><P></P><P>Thanks,</P><P>Miguel</P></BODY></HTML> Wed, 16 Oct 2019 14:24:03 GMT Miguel-Fernandez 2019-10-16T14:24:03Z Is relating tables the right solution? https://community.esri.com/t5/arcgis-pro-questions/is-relating-tables-the-right-solution/m-p/97797#M3981 <HTML><HEAD></HEAD><BODY><P>I am trying to analyze commute patterns using LODES data from the US Census. I downloaded a table that contained fields for home_census_block, work_census_block, and num_of_jobs. I joined that table to the census block geography using home_census_block as my join field. I then made a selection of census blocks that I wanted to analyze as the starting location for the commutes and made a new layer from that selection. I then created a relationship between the census block geography layer and the census block selection. The parameters for the Add Relate tool are:</P><P></P><P>Layer Name: census_block_geography</P><P>Input Relate Field: census_block_geography.GEOID10</P><P>Relate Table: census_block_selection</P><P>Output Relate Field: work_censusblockID</P><P>Cardinality: One to many&nbsp;</P><P></P><P>The Add Relate tool runs fine with no errors but I can't seem to get what I want. What I'm trying to see is what census blocks people are working in that live in the selected area. I have tried using the 'select related records' from the attribute table menu but nothing happens. I'm wondering if this is the right approach or is there something different I should be doing to get the desired results. Any guidance would be much appreciated.</P><P></P><P>Thanks,</P><P>Miguel</P></BODY></HTML> Wed, 16 Oct 2019 14:24:03 GMT https://community.esri.com/t5/arcgis-pro-questions/is-relating-tables-the-right-solution/m-p/97797#M3981 Miguel-Fernandez 2019-10-16T14:24:03Z Re: Is relating tables the right solution? https://community.esri.com/t5/arcgis-pro-questions/is-relating-tables-the-right-solution/m-p/97798#M3982 <HTML><HEAD></HEAD><BODY><P>Unfortunately you cannot make symbols, definition queries, or queries based on a relate.</P><P></P><P>I think you can do it with some sort of relate table but I have worked on that&nbsp;yet.</P><P>Try a JOIN instead</P></BODY></HTML> Wed, 16 Oct 2019 17:35:03 GMT https://community.esri.com/t5/arcgis-pro-questions/is-relating-tables-the-right-solution/m-p/97798#M3982 RobertBorchert 2019-10-16T17:35:03Z