F_ELEV, T_ELEV in point shape file

Discussion created by rshahid on Dec 23, 2012
Latest reply on Dec 26, 2012 by rshahid
I got road file with From Node ID and To Node ID in separate fields. I also got another file (point shape file) with Node_ID and Relative Elevation field. I want to add two fields in my road shape file that represents FromNode Elevation (F_ELEV) and ToNode Elevation (T_ELEV) based on the point shape file's relative road elevation field.
I tried join first with From Node to Node_ID and saved this file and then performed the same with To Node to Node_ID. The problem with this is it does not take into account coincident nodes with varying relative elevation to model bridge and overpass/underpass. Any suggestions how to handle this problem?