Results 1 to 3 of 3
  1. #1
    joberti is offline Novice
    Windows 10 Office 365
    Join Date
    Mar 2020
    Posts
    6

    Creating Subtasks using the Project Management Template in Access

    Hi, I am very new to Access and I am trying to create a Task tracking tool. I have decided to leverage the Project Management template in Access, however, I want to be able to include several levels of subtasks. I am more interested in automatically creating the subtasks and the numbering included as well. Can someone please provide guidance to the best approach in doing this?

    1. Main Task
    1.1 Sub Task 1


    1.2 Sub Task 2
    1.2.1 Sub Sub Task 2 (optional)

  2. #2
    Join Date
    May 2018
    Location
    Living in Scotland UK
    Posts
    1,557
    Hi

    You would need a table to record your Main Tasks with a PrimarkKey MainTaskID

    You would then need a related table for SubTasks with a PrimaryKey of SubTaskID and a ForeignKey of MainTaskID which you link to the PK in MainTasks

    Repeat this process for SubSubTasks
    You can PM me if you need further help.
    Good Reading https://docs.microsoft.com/en-gb/off...on-description

  3. #3
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,399
    in addition to the fk to the parent task, your table will also need an order field to maintain your order of sub and sub sub tasks

    potentially you are moving into the realms of recursive programming. Access queries cannot do recursion although if the maximum 'depth' level is known (task>sub task>sub sub task=3 levels) you can mimic it. Otherwise you will need to resort to using VBA for recursion.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 10-21-2016, 11:26 AM
  2. Project Management
    By Joehayner in forum Access
    Replies: 2
    Last Post: 08-13-2015, 08:38 AM
  3. Replies: 2
    Last Post: 04-11-2014, 11:21 AM
  4. Project management database
    By Alfi83 in forum Database Design
    Replies: 2
    Last Post: 12-16-2013, 07:31 AM
  5. Contract Management project
    By TheEngineer in forum Access
    Replies: 4
    Last Post: 07-16-2010, 02:57 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums