AnsweredAssumed Answered

Relating Tables one to many problems

Question asked by rharvell@rogersgroupinc.com_rogersgroupinc on Sep 13, 2019
Latest reply on Sep 18, 2019 by LanceCole

 I have one csv. file with geologic core hole the fields are its name and its northing and easting. In my other csv. file I have the core log data, so each hole drilled has multiple rows of corresponding strata thickness in the core log. My related columns in both tables are the core hole name, so I am relating one to many. My problem is when I go to relate them and select the point on the map only the first row of data shows up and I have to arrow to the next row and so on, does anyone know how to make it show all the rows of data when I select the point on the map?

 

This is my first table I import and turn into a points layer. Everything here is fine and how I want it and in the right location. 

 

Drillhole nameNorthingEastingSurface
07RU015648151809307720
07RU025633581809476724
208-98-1565786.11811581750.81
208-98-2565762.51810901771.4
208-99-1564668.11811355800
208-99-2566250.31811398731.61
208-99-3566602.41811059728.6
2000-1565024.61811063633

 

I then bring in the table below, and try to relate it (not all data shown in the table below) but it only allows me to join. And from here I cannot get it to do what I want. Which is I would like to be able to relate the table and be able to click to point and see all the rows of drill hole data associated with that one point. Thanks for the help and I look forward to hearing back 

 

Drillhole nameNorthingEastingSurfaceStrata nameBed NameKeyTop DepthBot Depth
07RU015648151809307720LimestoneCARTERSy034
07RU015648151809307720LimestoneLebanony34150
07RU015648151809307720LimestoneRIDLEYy150250
07RU025633581809476724LimestoneCARTERSy034
07RU025633581809476724LimestoneLebanony34148
07RU025633581809476724LimestoneRIDLEYy148250
208-98-1565786.11811581750.81OverburdenOVERBURDENn010
208-98-1565786.11811581750.81LimestoneLebanony1090
208-98-1565786.11811581750.81LimestoneRIDLEYy90250
208-98-2565762.51810901771.4OverburdenOverburdenn010
208-98-2565762.51810901771.4LimestoneLebanony10110
208-98-2565762.51810901771.4LimestoneRIDLEYy110250
208-99-1564668.11811355800LimestoneCARTERSy023
208-99-1564668.11811355800LimestoneLebanony23122
208-99-1564668.11811355800LimestoneRIDLEYy122150

Outcomes