This if a very simplified example of a problem I'm having. It's something like the cart before the horse before the cart... The real code is using various IF logic conditions to try and make the stuff inside the SCAN appear in the correct order and for the correct FundType. It doesn't do it very well, and I think there is a simple way, but I can't find it. Any help appreciated. In trying to simplify it I may have made it harder to understand, so let me know if you need more info.

Cursor: crsDisclaimers

DisclaimerID     DisclaimerText


Cursor: crsFunds

FundTypeID     FundName     FundID     DisclaimerID


SELECT crsFunds (ORDERed by FundTypeID)
SCAN

	* Make the results do this:
	
	Top Disclaimer (SQL from crsDisclaimers for the FundType)

	DISPLAY individual fund records for the FundTypeID

	Bottom Disclaimer (SQL from crsDisclaimers for the FundType) *
	Footnotes (SQL from crsDisclaimers for the FundType)

ENDSCAN

* These two sections need to only display after the individual records. The problem is by the time I know that the FundTypeID has changed, I'm already on the next record and my SQL (or IF logic) is not referencing the next FundType records.