Solved

Need to setup tables with the following relationships

Posted on 2015-01-29
4
117 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
  • 3
4 Comments
 
LVL 92

Accepted Solution

by:
Patrick Matthews earned 500 total points
Comment Utility
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 92

Expert Comment

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

Author Closing Comment

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

Expert Comment

by:Patrick Matthews
Comment Utility
Glad to help
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

763 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

Need Help in Real-Time?

Connect with top rated Experts

6 Experts available now in Live!

Get 1:1 Help Now