report is repeating two fields across dates

[littlered136]

Hi

I have a database that generates a report across a selection of dates, showing what scenes are to be filmed on each date. I recently added in the scene layout the two fields - Year set in and INT/EXT, however when I ask it to generate a report it will repeat these two fields on every date with the number input in the first record. 

None of the other fields do this. The fields are in the same 'scenes' table as all the other fields used in the report. I have added fields before and this has never happened. I have tried to see what is different, but the set up for both fields seems to the same as all the others.

 

if you are in the scenes layout and go to report tab, and ask for a one unit report. you will see date 2 has the year the same as date 1 and the INT the same. but if you go to the scene record you can see it is different. 

 

Please can I get some help to see what has gone wrong and how I can fix it if possible. 

 

Thank you in advance

Dtabase tester.fmp12

Edited January 5, 2022 by littlered136

[comment]

It's a little bit too much to take in. The problem you describe is most often caused by using a field from the wrong occurrence of a table. When I look at your One Unit Report layout, I see that the Year set in field is coming from the All Scenes TO, while most other fields are taken from the Scenes TO.

HTH. If not, try to reproduce the problem in a simple file.

[littlered136]

Oh wow yes that is it.. thank you.. I think I was trying for too long I missed that bit it had all scenes. thank you so much for helping me fix this.