I have listA and another ListB
When i a user views an item in ListB there is a custom button that the user clicks. Now when the user clicks the button i insert some rows into ListA which are: 1) The ID of the item in ListB 2) The username of the user.
So listA looks like this.
ID username Title 13 userB Boy 15 userA Trouble2 15 userA Trouble2
ID Title 13 Boy 14 Girl 15 Trouble2
Now you can see this means that user A has clicked the item 15 twice which is Title Trouble2.(I mean ID 15 has been inserted twice see above)
So i would like to show a view like this(When userA logs in he sees the below)
ID username 13 Yes 14 No 15 Yes
Any ideas and thanks in advance