Distance from multiple points to single lines based on similar field

Discussion created by seanlawrence on Jun 9, 2011
Latest reply on Jun 10, 2011 by gabrisch
I'm looking to do a join and distance calculation based on a common field that resides in both features being joined.

I have multiple points per segment and want to calculate the distances of those points, that are related to, individual segments.  A traditional spatial join won't be able to help me seeing it only takes 'closest points'.  I've searched and couldn't come up with anything other than manual spatial joining selected points to it's respective line.

Any thoughts?

ArcMap 9.3 (Build 1770) No network analyst.