Summary from a related table

[peterc]

I am helping someone with this problem and now I am stuck. They have a list of contracts and a list of files in separate tables. Each file is assigned to a contract. They need to be able to create a report that lists all the contracts and what files have been assigned. (this should be so simple). If I create the report from the contract table, I get all the contracts but cannot work out how to get all the files. A summary report that contains records from related table does not seem to work. If I create a report from the file table, then contracts with no data cannot be listed. My two ideas for work arounds are to create a dummy file and assign every contract that or set up a portal with 50 rows in the contacts table report and use the slide up when printing. Both work but there has to be a more elegant solution. Oh Really!

[aaa]

Other sulution may be such.

Each contract when is creating creat autmaticaly one empty row in related file. Then use summary report in related table.