Calculate 1:1 relationship and distance on two point data sets

Discussion created by milesmac73 on Jun 9, 2014

I've got two point data sets for the location of schools (with postcodes). However, as one data set is geocoded and the other data set is more accurate (primary) data, they have different Eastings and Northings coordinates (British National Grid).

There's two things I'd like to achieve:

1. Join/relate the two data sets, based on the points in each layer having the same postcode
2. Measure the distance between the points that have been 'joined'

I'd like to do something similar to the existing Near function but rather than create a 1:n (one-to-many) relationship, I need a 1:1 relationship.

Any ideas on how this could be done?

Many thanks,