Can Job Table hold more than one Task foreign key
I have a Job Table in which a new record equals each job. There is a long list of Tasks (in a Task table) from which the User can select any number to be part of the Job.
Production needs the Job with only the Tasks selected by the User. Production will make notes on each Task as they work them.
Some how I have confused myself on this should work.