I have two tables with a one-to-many relationship: the Innovation table, which contains a list of innovations, and a Vote table, which contains votes cast for each innovation. The tables are joined on the InnovationID field. I want to show a list of Innovations for which the current user has NOT voted, meaning there is no record in the Vote table for this innovation from this voter.
I can show a list of innovations for which there are no votes by left outer joining the Innovation and the Vote table on the InnovationID vield in the Vote table and specifying records where it is Null.
I can show a list of innovations for which the current user has not voted with a where clause that filters on a specific Voter_ID (found in the Vote table). But I update this for the current user in a before SQL query event.
How can I show a list of innovations for which the current user has not yet voted?
Douglas