How To Display Name Only ?

[Tommy]

Hello everyone. I am new here and need some guidance.  I am running the latest version of Uniserver Zero as I installed it last week.

I am using phpmysqladmin's UI to create my tables within my database and also to add the records within them.

I have a table called 'sports_league' that contains seven records. Its primary key is 'Sports_League_ID'.

I also have another table called 'past_league_results' that has it's primary key as 'Past_League_Results_ID" as well as an index field called 'Sports_League_ID" with a foreign key called 'FK_sports_league' that connects the 'Sports_League_ID' to the 'Sports_League_ID' to the Sports_League' table with the 'Choose column to display' value set to Sports_League_ID.

My problem as you can see in screenshot.jpg, is that when I try to insert a new record and select the Past_League_Results using phpmysqladmin, the sports_league_ID drop-down list of the seven records displays both the League Name and also the primary key value in two separate ways.  How can I fix it so that it ONLY displays the League Name and only display one set of records from the Sports_League table?

Any help would be greatly appreciated!

 

thx

Tommy