The reason I use userID to check or uncheck is because I only want the ones that userID 116 has access to to be checked when rendered. It works if I simply let it show the duplicate venues with a simple INNER JOIN query because it's pulling all the venues that 113 owns and checking the ones that 116 has access to. The problem is the duplicates showing.
For instance, instead of seeing a list of checkboxes with Club 1 and Club 3 checked:
[x] Club 1
[ ] Club 2
[x] Club 3
where userID 116 has access to club 1 and 3 I get:
[ ] Club 1
[ ] Club 1
[x] Club 1
[ ] Club 2
[ ] Club 2
[ ] Club 2
[ ] Club 3
[ ] Club 3
[x] Club 3
above is basically showing all the records (and users) that have access to clubs that are owned by 113 and checking the proper Clubs that userID has access to. My goal is the weed out the duplicates. I change the query to do that, but then it doesn't check them.
Maybe I just need to figure out a different way to structure my one to many relationship, but everything I've read on it seems to point to this way. I think the key is the proper query.
Sorry if I am confusing you Jason...haha