Sorry for the ambiguous title to this post - but there really was no way to explain it - but an image would show exactly what I am trying to achieve (see image below).
Currently - the data on the left hand table is from a linking table, that links the sector issues with a sector.... (tbl_link_sector_issues_and_sectors) - Screen capture below.
The data on the right hand side, is just all sector issues (tbl_sector_issues)
I'd really like to be able to
- Select a sector (as in the screen shot below) and it shows all the sector issues for that sector (this currently works) but......
- I'd like the table on the right to only show the 'remaining' sector issues (I.e. those not linked).
- And finally - I'd like to be able to add or remove a sector issue from a sector using the add /remove buttons.
Edit: I think the add part is pretty straight forward. I can take the id of the sector issue on right hand table, take the id of the sector selector up top - and then create a new record in my linking table.
But removing - and keeping the table on the right more accurate (I.e. not showing the issues that are already on the left) is tricky. And makes me think there is a better way of doing this.
Can someone point me in the direction of where I should be looking to achieve this?
hope to hear,