We'd need to know how you have set up the report and what kind of relationship links table 1 to table 2. Can you describe what is not being refreshed? data from new records in table 2? Data changed in existing records in table 2? Or?
Is data from table 3 included in this report also?
You do not say, but assume you are using FMP ver 10 or greater. Mac or Win should not matter.
Have you created a Dynamic report before? and had it work?
Google "dynamic reports filemaker"
FileMaker Pro 10 - Dynamic Reports - VIDEO
Interactive Dynamic Subsummary Reports Viewable in Browse Mode
How do dynamic Subsummary reports work? Updated: Nov 28, 2011Creating dynamic reports in Table ViewYou can use Table View into group your data by a field, display subtotals for a field, or create subtotals for each group of data.Note You can view the quick report only in Table View. The changes you make have no impact on the current layout.
Sorry for my unclear question. I solved the problem but I am not sure how. I used to move fields from Table 2 from body region to subsummary region on my layout (for some unrelevant reason). And then I decided to keep some of them in body region for a better design. And I think that was the solution. I am using FM pro 11.