Access Displaying two connected tables in one form

Hi

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 BrownMicrosoft Cloud Azure/Excel Solution DeveloperAsked:
Who is Participating?
 
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.
0
 
Jeffrey CoachmanMIS LiasonCommented:
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.

JeffCoachman
0
 
Jeffrey CoachmanMIS LiasonCommented:
somewhat like this:
Database31.mdb
0
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Thank you both
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.

All Courses

From novice to tech pro — start learning today.