I have a sort of complex query to write and I don't know where to start. Basically, there are list and detail pages of candidate answers on a site. There are readers assigned to certain candidates. Is there a way to display a list page showing only the candidates assigned to that particular reader? There are two separate user levels in the database user table for readers and candidates.
And also, based off this, another part is added. Once a Chaplain signs off on a candidate answer, we need to be able to restrict readers from returning to that particular candidate detail. I was thinking about doing something in a recordset for this:
WHERE score_overview.chaplain_review= null OR blank
so that if it reads a chaplain has already checked it off, it won't allow the reader back. But how would I actually set up the restriction through a recordset?? Thanks in advance.