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
