I am creating an Access database that contains a lists of tasks. MY QUESTION IS is there a way to create a query to pull a subset of those tasks to be included in a job? As new jobs are created, I need a way to include a new subset of tasks in a report without have to input all of the tasks needed all over again. To further illustrate my question:
Job # 1 includes tasks 1, 2, 4, 9 & 10
Job # 2 includes tasks 1, 3, 4, 10 & 11
I need to create a report for each new job comes along that lists each task to be included for that job. It can be done by having a separate field in the task table for each job and set the value for yes or no, but there must be an easier way of doing this.