Using Global in Header to link to parent record

[coldspring]

I have a report that requires a lot of the detail in the child file and the header information from the parent file. I have setup a Global field in the child file to link to the key in the parent file. I have two issues:

1. I cannot change the value of the global when it is placed in the header.

2. Randomly (it seems), the global is set to one value but the information in the header is from a different linked record (e.g. the child file Global value = 1, but the information returned in the header is from record where ID = 8). Very baffling...any help is much appreciated.

[Vaughan]

Try using a Leading Grand Summary instead of a Header part... it's different but the LGS works much better for this stuff, particularly if it's sorted and sumarised.

[coldspring]

Yee Haw...thanks for the tip...working well now.