Access Linking a Job Number to multiple task numbers...

[FusionAu]

Hi Guys,

So I am graphic designer that has been asked to get my head around access... I have done multiple tutorials to get the fundamentals behind me, but seem to have a few issues on the best ways of setting out what I have in mind.

So the set out I have used is creating a table called tblProjects - this will be the area where all new projects are added as they come in including details such as a ProjectID ProjectNumber ProjectDescrition Client Name etc. etc. etc.

For costing purposes we also have task numbers that need to sit under an individual Project Number EG.

ProjecNumber: 13001


Task1 : Preliminaries
Task2 : Overheads
Task3 : Design
Task4 : Programming

ProjectNumber: 13002
Task1 : Engineering
Task2 : Drating
Task3 : Construction


So the plan was to create another table called tblJobTasks

How then does one go about linking the project number to the job tasks... and following on I suppose where I want to get to with this is on a form having a drop down that selects the job number then another drop down that has a list of tasks specified to that particular job so when the girls are doing the data entry from a time sheet she only sees the list of tasks associated with the particular job selected in the first place...

Sorry if this is a newbie question... My database will look pretty but might not work -

Lee.

[orange]

I recommend you work through this tutorial from RogersAccessLibrary. If you work through it, you will learn about entities and attributes and tables and relationships.
There are answers in the tutorial. Do the example, then do the same thing with your database.

good luck