I have an address point with street name and street type fields like
Name TypeMain streetPlesantavenueand so on. Also i have table with street coded values like
CodeNameType2345Main street4588PlesantavenueWhat i need to do is for each addreess point find name and type from second table and paste code value to the point attribute. What is the best way for this?