Here is what I'm trying to do.
I'm adding a point of interest (POI) onto a map and want it to utilize the parcel to populate my Facility Address field. However, using the parcel information requires using multiple fields to "CREATE" the address correctly. The parcel layer has a, STRNO, STRNAME, STRTYPE that need to be concatenated into one field in my POI layer.
I was thinking of using the NEAREST_FEATURE with a �??value info�?� like this:
parcels | STRNO+" "+STRNAME+" "+STRTYPE | 0.5
or perhaps
parcels | STRNO&" "&STRNAME&" "&STRTYPE | 0.5
However, this doesn't work out so good for me at this point. Perhaps there is a rather simple solution to this or perhaps not.
Also, my parcel data is in SDE and I have to join that Parcel layer with a table in order to get the address fields I need. During testing when I was simply getting one field it wouldn't let me do this at all with SDE. Perhaps it's the join not allowing me to do this or perhaps it because this data is in SDE while I'm editing in a FGDB outside of SDE. Any ideas on this would be greatly appreciated. I got it to work by exporting out a few parcels from this joined layer for testing purposes.
1. Can I concatenate these values shown above?
2. Why can't I access my joined SDE layer in my "Value Info" field?
Thank you!