I forgot to add a ID to each Political Party and their Policies! Why is this a problem I hear you ask!
Well the initial [first] results screen should look like the screen on the left and not the screen on the right!
To solve this issue I have created/inserted another column into my tables called ‘Party ID’. This table will hold the Political Parties Unique Identify which will be used to link all of the political parties policies to that party. I can’t believe I forgot to do this!!
Labour = 1
Liberal Democrats = 2
Conservative = 3
UK Independence Party = 4
Green Party = 5