I am trying to use the attribute assistant to concatenate several fields (civic number, road name, quadrant, etc) to create the resulting value in one field (full municipal address). One of these values is located in a related table.
Our municipality has a two-word standard for our road names, but in an ongoing effort to clarify what those abbreviations mean, we are trying to concatenate the full address with the full spelling of the road type (e.g: RD versus ROAD).
I have tried simply creating a join between the ADDRESS feature class the table, but the attribute assistant ignores the reference to the related table's field and concatenates the other fields properly.
I believe I read somewhere that all the fields have to be in the same table to concatenate, but wanted to make sure I was not missing out on an Attribute Assistant method I was unaware of.