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!!

Party ID’s:

Labour = 1
Liberal Democrats = 2
Conservative = 3
UK Independence Party = 4
Green Party = 5


Leave a Reply

Your email address will not be published. Required fields are marked *