Access Displaying two connected tables in one form

Posted on 2012-08-21
Last Modified: 2012-08-21

I have two tables in Access
Tasks - has columns ID, Task, Project, Description
SubTasks - has columns ID,SubTask,TaskID

[SubTasks].[TaskID] has a relationship with [Tasks].[ID]

how do I display this in one form so that tasks are shown on the to half and connected sub
tasks on the bottom. I want to show tasks per project
Question by:murbro
    LVL 74

    Assisted Solution

    by:Jeffrey Coachman
    Not sure of the exact output you need without and graphical example.

    But in a nutshell:
    Relate the tables in the database window.
    Select (don't open, just highlight) the Task table
    Click the "Create" tab on the ribbon
    In the "Forms" section, the "Form" icon.

    A Main/subform will be created automatically.

    LVL 84

    Accepted Solution

    Build a typical mainform/subform setup, with the mainform bsed on the Tasks table, and the subform based on the SubTasks table. The Subform link fields would be Tasks.ID and SubTasks.TaskID.

    As the user browses Tasks, the Subform would show all Subtasks related to the current Tasks.

    If you mean that "Project" is somehow different from a Task, then you'll have to explain the data relationships further.
    LVL 74

    Expert Comment

    by:Jeffrey Coachman
    somewhat like this:

    Author Closing Comment

    Thank you both

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    In the article entitled Working with Objects – Part 1 (, you learned the basics of working with objects, properties, methods, and events. In Work…
    I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
    As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
    Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

    779 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

    17 Experts available now in Live!

    Get 1:1 Help Now