Group Select

[lotharious]

Table info

Tasks Table -
PO -
Task - Task# - 1 - 24
DateComp - Date Completed
----
TaskSet Table
PO -
Set - Task Set (1 - 4)
Comp - Completed Y/N
----
TaskList Table
Task#
Set
Name
----

I need to get a list of PO/TaskSets that are not complete from the Task Table, so I may update the Comp field in the TaskSet Table. And a update query to update as well.

Issue Im having is that the individual task can be either completed or not. But it no all of the tasks in the set are complete, then the task set is not complete. I cant figure out if the taskset is complete or not, or how to distiguish individual records in the TaskSet table to update.

The TaskList, and TaskSet Tables are not set in stone. The fields can be added changed and so forth.