I am going to ask for if the University would pay for my membership in UT. In the meantime, I can not do a search (since it reqiures membership). Is there a link or where would I find how to design the looping in a different way (important for the preview, but would apply for the printer as well too). The following is my coding that I was able to "make it work", but not as user friendly. The AUTH table has merely 15 records, so it's a cute few pages, but that "supposely" be over hundreds, even thousands, so I gotta fix this... (I even have the FoxPro Advisor, Oct '98, nothing about that in there either).

SELECT org
SET ORDER TO main
GO TOP
SELECT auth
SET ORDER TO organizati
SELECT org
DO WHILE NOT EOF()
	SELECT auth
	IF SEEK(org.organization)
		SELECT person.name, ;
		auth.authtype, ;
		auth.limit, ;
		auth.fund, ;
		auth.project, ;
		auth.program, ;
		auth.account, ;
		auth.sfs, ;
		auth.mcc ;
		FROM auth ;
		JOIN person ON auth.id = person.id ;
		INTO CURSOR temp ;
		WHERE org.organization = auth.organization AND ;
		(auth.end > DATE() OR EMPTY(auth.end)) ;
		ORDER by person.name,auth.authtype
		REPORT FORM by PREVIEW
	ENDIF
	SELECT org
	SKIP
ENDDO

Chuck