I'm using dynamic text to put the page name on each layout page of a map series. The page name is a street address and is not necessarily unique from other page names. I'm also using dynamic text to insert a table attribute for the corresponding features. (Even if a street address is repeated, this other attribute is not.) I just discovered that if a page has a non-unique name/street address, the dynamic text will insert every corresponding value found in the table attribute, which is bad. I'm wondering if this is a bug or an expected behavior. Ideally the page names would be unique, but I didn't think it was a requirement until now. Just trying to assess the situation before I figure out a workaround. Thanks!
Example:
I add a feature with an address 123 Maple St and it has a corresponding table value of "foo". Later, another feature is added at 123 Maple St with table value "bar". Now, if I open the layout for either page, the dynamic text displays "foo bar".