Join and Relate Difficulties

[EthanGibbens]

Tract	Field	Tract - Table 2	Field - Table 2
100	1	100	1
100	2	200	10
200	5	200	11
200	10
200	11

(If I could post a screenshot I would, No permissions)

I am not great with terminology as I have basically no training but am expected to use ArcPro to do the very basics. Well, I would like to make my life a little easier and see if I can relate these two tables together so I can make better maps. 

I made an excel document with Tracts and Fields on it to try and join to a current layer my Organization has. The problem I am having now is when I join Tracts only, it with pull up the correct tracts but with ALL the fields as well and my goal is to only have the Tracts with the fields I need being shown. 

Is there a way to even do this? Tracts are polygons and there can be many field polygons within a Tracts 

[RPGIS]

HI @EthanGibbens,

If you want only specific fields to show from another table then a join makes the most sense. Relates only correlates one field to another field based on matching values. If you want the join table to join to each matching record but only include specific fields then you can try the following.

1. Export and join option
   1. Try exporting the table to only have the fields that you want plus the join field
   2. Create the join and it should only have the fields you exported shown.
2. Join then toggle fields
   1. Join both tables
   2. Click on the feature and select the "data" tab in the ribbon.
   3. In the data tab click on fields.
   4. Toggle the fields you only want to show/export
   5. (Optional) Export the joined table as a table of matching results.