How do you combine subform data with mainform data?

  • Thread starter Thread starter John
  • Start date Start date
J

John

Hello,

I have simple project tracking database. The mainform is used to enter data
about each project for four company divisions. The subform is tracks tasks
for every project. However, each project may not have tasks.

How can I create a report which shows data for ALL projects including tasks
by division? When I combine these two, only those projects with tasks are
included (I assume because a record was created for the task). My report
keeps excluding projects with no tasks.

Main table is linked to related table (one-to-many) via ProjectID:

Main:
ProjectID - primary key
ProjectName
Division
etc.

Related Table:
TaskID - primary key
ProjectID
Task
etc
 
John said:
Hello,

I have simple project tracking database. The mainform is used to
enter data about each project for four company divisions. The
subform is tracks tasks for every project. However, each project may
not have tasks.

How can I create a report which shows data for ALL projects including
tasks by division? When I combine these two, only those projects with
tasks are included (I assume because a record was created for the
task). My report keeps excluding projects with no tasks.

Main table is linked to related table (one-to-many) via ProjectID:

Main:
ProjectID - primary key
ProjectName
Division
etc.

Related Table:
TaskID - primary key
ProjectID
Task
etc
Click to expand...

Use an outer join in the query for the report. If you double-click the join
line and look at the choices it is pretty obvious which option to use.
 
Thanks Rick! I cannot believe how easy that was.

Rick Brandt said:
Use an outer join in the query for the report. If you double-click the join
line and look at the choices it is pretty obvious which option to use.
Click to expand...
 
Back
Top