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:
Contract 1 addendum
Contract 2 addendum
Contract 2 addendum b