If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Making Duties and Tasks on a table
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 |
#2
|
|||
|
|||
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 "KenRamoska" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|