Hi,
I was not sure how to word my problem to search for a solution, so will try and describe it here using simplified tables.
I have created two tables, Table A and Table B.
Table A can be thought of as a master table. It is a list of water bores H1-H13, each with a hole elevation (height above...