topic Attribute Assistant and M:N Relationships in Local Government Solutions Users Questions https://community.esri.com/t5/local-government-solutions-users-questions/attribute-assistant-and-m-n-relationships/m-p/831813#M329 <HTML><HEAD></HEAD><BODY><P>Has anyone had any luck using the Attribute Assistant to automatically update a M:N relationship class?</P><P></P><P>I have a building and parcel layer that are joined with a simple M:N relationship class - I can have multiple buildings in one parcel, and a building can also be in more than one parcel (not sure why... just the IT guy haha).&nbsp; </P><P></P><P>The problem is, I can't seem to get the Attribute Assistant to update the relationship class join table automatically when a new building is created or it's geometry is modified.&nbsp; It works for 1:M relationships where there's a primary and foreign key in the related tables themselves, but with many-to-many relationships, since it's using the intermediate table that is part of the relationship class, it has some trouble.&nbsp; I've experimented with Create Linked Records targeting the relationship class table with no success yet. </P></BODY></HTML> Sat, 16 Jan 2016 00:00:37 GMT JerryCorum1 2016-01-16T00:00:37Z Attribute Assistant and M:N Relationships https://community.esri.com/t5/local-government-solutions-users-questions/attribute-assistant-and-m-n-relationships/m-p/831813#M329 <HTML><HEAD></HEAD><BODY><P>Has anyone had any luck using the Attribute Assistant to automatically update a M:N relationship class?</P><P></P><P>I have a building and parcel layer that are joined with a simple M:N relationship class - I can have multiple buildings in one parcel, and a building can also be in more than one parcel (not sure why... just the IT guy haha).&nbsp; </P><P></P><P>The problem is, I can't seem to get the Attribute Assistant to update the relationship class join table automatically when a new building is created or it's geometry is modified.&nbsp; It works for 1:M relationships where there's a primary and foreign key in the related tables themselves, but with many-to-many relationships, since it's using the intermediate table that is part of the relationship class, it has some trouble.&nbsp; I've experimented with Create Linked Records targeting the relationship class table with no success yet. </P></BODY></HTML> Sat, 16 Jan 2016 00:00:37 GMT https://community.esri.com/t5/local-government-solutions-users-questions/attribute-assistant-and-m-n-relationships/m-p/831813#M329 JerryCorum1 2016-01-16T00:00:37Z