• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 140
  • Last Modified:

Need to setup tables with the following relationships

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
VGuerra67
Asked:
VGuerra67
  • 3
1 Solution
 
Patrick MatthewsCommented:
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
 
Patrick MatthewsCommented:
For your forms, I would have a form for tblTaskHeader, and then have a related subform for tblTaskDetail.
0
 
VGuerra67Author Commented:
Thank you very much for guiding me in the right direction.  Your information was exactly what i needed.
0
 
Patrick MatthewsCommented:
Glad to help
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now