What am I doing wrong here? I am trying to relate a table with multiple rows of data to another table that has one row of data with the coordinates for that point. The "Lith" table contains the lithology and intervals for the on water well that was drilled which is shown on the TX Well location table. The well location table only has on row for each hole & has the coordinates for that hole. How do I relate the "lith" table with its many rows to that one hole from the tx well data? As you can see in the images "WellReportTrackingNumber" is my relating field for both tables? 
My workflow for what I have tried so far is the following:
1. Import both tables (Lith) & (Tx Well Location) which I also plotted.
2. Click on the plotted point layer > Add Relate & then do the following.
After this I try and check the join but nothing seems to have happened. 
Any help would be appreciated, thanks!
