AnsweredAssumed Answered

Is relating tables the right solution?

Question asked by miguelf88 on Oct 16, 2019
Latest reply on Oct 16, 2019 by rborchert

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:


Layer Name: census_block_geography

Input Relate Field: census_block_geography.GEOID10

Relate Table: census_block_selection

Output Relate Field: work_censusblockID

Cardinality: One to many 


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.