Solved

How do I create one report which combines multiple tables?

Posted on 2010-08-24
2
575 Views
Last Modified: 2012-08-14
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
Comment
Question by:nisupport
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 12

Accepted Solution

by:
North2Alaska earned 250 total points
ID: 33517214
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
 
LVL 6

Expert Comment

by:ThomDroz
ID: 33519150
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

[Webinar] Learn How Hackers Steal Your Credentials

Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them. Thursday, July 13, 2017 10:00 A.M. PDT

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Problem: You have a hosted FileMaker database and users are tired of having to use Open Remote or Open Recent to access the database. They say, "can't you just give us something to double-click on rather than have to go through those dialogs?" An…
Having just upgraded from Filemaker 11 to Filemaker 12 over the weekend, we thought we would add some tips for others making the same move.  In general, our installation went without incident. Please note that this is not a replacement for Chapter 5…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

707 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