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

How do I create one report which combines multiple tables?

I am creating two tables: one is for contracts and the other is for contract addendums. The addendums will be related to the contract table through the contract unique identifier. We track the overall project and then all the changes (addendums).

Is there a way to create a report that combines the contracts and addendums  and displays a row for each?

The results would be like this:
Contact 1
Contract 1 addendum
Contract 2
Contract 2 addendum
Contract 2 addendum b
0
nisupport
Asked:
nisupport
1 Solution
 
North2AlaskaCommented:
Yes, FM does this well.  You will use the addendums as the body data and the contract as sub summary data.  Using the relationships you have the sub summaries print when the contract changes.
0
 
ThomDrozCommented:
nisupport

Are you sure it is a report you want?  If so North2Alaska answer should help.

This can also easily be created in a layout format based on "Contracts" table
Insert a portal from the "Addendums" table and this would allow easy viewing and adding of addendums to the Contracts.


Thom Droz
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

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