Here is what I am trying to accomplish:
So here is what I want: a query that lists readfiles that don't have an entry in the signedoff table for each user. For example if I have user 1 & 2, and 3 readfiles (1,2,3) and user 1 has signed off 1 & 2 and user 2 has signed off 2, the output should be something like:
user _id readfile_id
Does this make sense? It would also be equivalent to having a question bank and seeing which questions weren't answered by each user.
Thanks for your help.