Error when generating diagram from custom queries

[ElenaCannon]

I am trying to use custom queries from feature classes and tables. The feature classes represent nodes and the tables have the linking information.

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.

I am not sure why I get this message but I haven't found an answer yet.

[RickAnderson]

When you are creating your custom queries, you specify what the Identifier will be.  The identifier you have chosen must not be a unique field in the data to get this error.  You have at least 2 records returning an identifier of 'Wholesales'.  Choose a different Identifier that is unique and you shouldn't get this message.  On the resource center there is a video in the schematic video series talking about custom query diagrams that might be useful to review.