Learn how to a build a cloud-first strategyRegister Now

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

Access Displaying two connected tables in one form


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
Murray Brown
Murray Brown
  • 2
2 Solutions
Jeffrey CoachmanCommented:
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, ...click the "Form" icon.

A Main/subform will be created automatically.

Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
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.
Jeffrey CoachmanCommented:
somewhat like this:
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Thank you both

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

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