Making Duties and Tasks on a table

[Guest]

Hello
I am a bit confused on table construction. I thought I was ok with Access
but here is my question.
I want to create a form based on a table. Simple...yes.
BUT here is my source of confusion.
I have to type in Duties and these Duties have tasks.
Everything would be under the JOB
SO
I know I have a JOB field...job id...etc.
But how do I structure the table so that when they enter duty then can then
enter more than one task associated with the duty and the duty has more than
one duty associated with the job.
I hope I was clear and thanks in advance to anyone that can help me clear
this up.
Ken

 

[Rick B]

Sounds like a couple of One-to-Many relationships.

You would need a Job table listing all the Jobs.

You would need a duty table with two fields (or more) with the first one
being the job or job id, and the second field being the duties. This table
would have multiple entries for each job depending on how many duties were
associated with a given job.

You would need another table of tasks. This would have a Duty field and a
task field. Again, you would have multiple records if a duty has multiple
tasks.

Rick B