Related Records Not Showing in Report

[JNJ3120]

Greetings all,

I am attempting to generate a report that has fields from two tables, Companies & Stocks. The tables are related based on CompanyName. In this database a company can have multiple stocks. When I create the report, utilizing a few fields from both tables, only the first stock that has been entered into the stocks table for each company is shown. So, if Company ABC has stock ABC1, ABC2, and ABC3, only the one which was entered first will show in the report. What I need, however, is for it to show all stocks under any company. One thing that I did notice is that if I changed the name of a stock that is one of many of a company, it then showed up in the report. So I am a bit perplexed. Any suggestions?

[comment]

Produce your report from a layout of the Stocks table, sorted by company. Place fields from the Companies table in a sub-summary part.

[JNJ3120]

Ok, thanks a lot. Worked like a charm. I really appreciate it.