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
Today is tomorrow's yesterday.