topic Error when generating diagram from custom queries in Mapping Questions https://community.esri.com/t5/mapping-questions/error-when-generating-diagram-from-custom-queries/m-p/111919#M1340 <HTML><HEAD></HEAD><BODY><SPAN>I am trying to use custom queries from feature classes and tables. The feature classes represent nodes and the tables have the linking information. </SPAN><BR /><BR /><SPAN>I set up the schematic diagram template with nodes pointing to the feature classes and links refering to the tables with the information to join the nodes. </SPAN><BR /><BR /><SPAN>I am not sure why I get this message but I haven't found an answer yet.</SPAN></BODY></HTML> Tue, 26 Feb 2013 21:53:31 GMT ElenaCannon 2013-02-26T21:53:31Z Error when generating diagram from custom queries https://community.esri.com/t5/mapping-questions/error-when-generating-diagram-from-custom-queries/m-p/111919#M1340 <HTML><HEAD></HEAD><BODY><SPAN>I am trying to use custom queries from feature classes and tables. The feature classes represent nodes and the tables have the linking information. </SPAN><BR /><BR /><SPAN>I set up the schematic diagram template with nodes pointing to the feature classes and links refering to the tables with the information to join the nodes. </SPAN><BR /><BR /><SPAN>I am not sure why I get this message but I haven't found an answer yet.</SPAN></BODY></HTML> Tue, 26 Feb 2013 21:53:31 GMT https://community.esri.com/t5/mapping-questions/error-when-generating-diagram-from-custom-queries/m-p/111919#M1340 ElenaCannon 2013-02-26T21:53:31Z Re: Error when generating diagram from custom queries https://community.esri.com/t5/mapping-questions/error-when-generating-diagram-from-custom-queries/m-p/111920#M1341 <HTML><HEAD></HEAD><BODY><SPAN>When you are creating your custom queries, you specify what the Identifier will be.&nbsp; The identifier you have chosen must not be a unique field in the data to get this error.&nbsp; You have at least 2 records returning an identifier of 'Wholesales'.&nbsp; Choose a different Identifier that is unique and you shouldn't get this message.&nbsp; On the resource center there is a video in the schematic video series talking about custom query diagrams that might be useful to review.</SPAN></BODY></HTML> Wed, 27 Feb 2013 18:59:24 GMT https://community.esri.com/t5/mapping-questions/error-when-generating-diagram-from-custom-queries/m-p/111920#M1341 RickAnderson 2013-02-27T18:59:24Z