Solved

Need to setup tables with the following relationships

Posted on 2015-01-29
4
127 Views
Last Modified: 2015-02-02
trying to setup tables with the following relationships to be later used in a form.
I need to create a form to track task for clients.
However, I would like to be able to add multiple individual task to one task.
can someone point me in the right direction?
0
Comment
Question by:VGuerra67
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
4 Comments
 
LVL 93

Accepted Solution

by:
Patrick Matthews earned 500 total points
ID: 40577967
I would go with something like this:


tblClients
-------------------------------------
ClientID (PK)
ClientName
<other attributes>

tblTaskHeader
-------------------------------------
TaskHeaderID (PK)
ClientID (FK)
TaskHeaderName

tblTaskDetail
-------------------------------------
TaskDetailID (PK)
TaskHeaderID (FK)
TaskDetailName
TaskDetailStartDate
TaskDetailEndDate
<other attributes>


The idea is that each "master task" gets one record in tblTaskHeader, and then each "master task" has one or more related records in tblTaskDetail.

If you are assigning employees to the detail-level tasks, then I would add the following tables:

tblEmployees
-------------------------------------
EmployeeID (PK)
EmployeeLName
EmployeeFName
<other attributes>

tblTaskDetailAssignments
-------------------------------------
TaskDetailAssignID (PK)
TaskDetailID (FK)
EmployeeID (FK)

This allows you to assign more than one employee to a detail-level task.
0
 
LVL 93

Expert Comment

by:Patrick Matthews
ID: 40577972
For your forms, I would have a form for tblTaskHeader, and then have a related subform for tblTaskDetail.
0
 

Author Closing Comment

by:VGuerra67
ID: 40582696
Thank you very much for guiding me in the right direction.  Your information was exactly what i needed.
0
 
LVL 93

Expert Comment

by:Patrick Matthews
ID: 40584441
Glad to help
0

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

635 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question