AnsweredAssumed Answered

Using the attribute Assistant to populate a second lookup value

Question asked by agaiser on Apr 17, 2012
Latest reply on Feb 16, 2016 by mmiller-esristaff
My apologies that this isn't specifically a water utilities issue, but this forum seems to have the most traffic in relation to the Attribute Assistant, so I thought I would post here.

I am using the attribute assistant (which by the way I think is wonderful) but I have run into a bit of a problem. Here is the scenario:

I have road names that are created and maintained in a separate non spatial Oracle Database.
I am creating spatial locations in an Oracle SDE geodatabase and need to lookup a road name and copy the value to the spatial feature.
I am using the attribute assistant and the validate_attribute_lookup value method to get the road name and it works great.

Now, what I need to do is while I am looking up the road name value, I need to get the unique road name id (another value associated with the table entry). Any suggestions on how I could do this? The road name ids are gibberish so the lookup is not helpful. Ideally, I would just like it to grab two pieces of information when I am doing the lookup.

All suggestions are welcome.