<div>
nisupport<br />
<br />
Are you sure it is a report you want? &nbsp;If so North2Alaska answer should help.<br />
<br />
This can also easily be created in a layout format based on &quot;Contracts&quot; table<br />
Insert a portal from the &quot;Addendums&quot; table and this would allow easy viewing and adding of addendums to the Contracts.<br />
<br />
<br />
Thom Droz
</div>


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

<div>
<div class="content wysiwyg-content">
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).<br />
<br />
Is there a way to create a report that combines the contracts and addendums &nbsp;and displays a row for each? <br />
<br />
The results would be like this:<br />
Contact 1<br />
Contract 1 addendum<br />
Contract 2<br />
Contract 2 addendum<br />
Contract 2 addendum b
</div>
</div>


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

How do I create one report which combines multiple tables?

FileMaker Pro is a cross-platform relational database application that integrates a database engine with a graphical user interface (GUI) and security features, allowing users to modify the database by dragging new elements into layouts, screens, or forms. FileMaker evolved from a DOS application, but since 1992 has been available for Microsoft Windows and Mac OS, and can be used in a cross-platform environment.