🚀 go-pugleaf

I have 2 dbf files. One has a class room number field. The other has
student info and a class room number field. I built a query indexing
these 2 with class room number. I want to select a class room from a
combobox that points to the class room dbf and create a view of only the
students in that class room. When I step thru the dbf if I reach the end
of that class room it gives me an eof and like wise for stepping
backwards. I thought this query would do that, but it does not. I
inculded the qbe. It has some other dbf files for processing by the
form.

                 Thanks. Don

* Visual dBASE .QBE file 9
CLOSE DATABASES
SET EXACT ON
SELECT 1
USE CLASSRM.DBF
SELECT 2
USE STUDENT.DBF ORDER TAG  CLASSID
SELECT 1
SET RELATION TO CLASSID INTO STUDENT CONSTRAIN
SET FIELDS TO CLASSID, CLASSNUM
SELECT 2
SET FIELDS TO CLASSID, STUDENTNUM, FIRST, MIDDLE, LAST, STREET, CITY,
ZIP, ;
STATE, HOMEPHONE, BUSPHONE, SS, DOB, REFERAL, AGE, HIGHSCHOOL,
ENROLLDATE, ;
PAIDDOWN, DISCOUNT, REASON, AMOUNTOWED, CONTROL_N, CLASSCOMPL, NOTES, ;
MISSEDCLAS, DRIVECOMPL, OBSERVECOM, CERTIF, LICENSE, EXPIRE, DAY1, DAY2,
;
DAY3, DAY4, DAY5, DAY6, DAY7, DAY8, DAY9, DAY10, DAY11, DAY12, DAY13,
DAY14, ;
DAY15, DAY16, DAY17, DAY18, DAY19, DAY20, DAY21, DAY22, DAY23, DAY24,
DAY25, ;
DAY26, DAY27, DAY28, DAY29, DAY30, DAY31, DAY32, GR1, GR2, GR3, GR4,
GR5, ;
GR6, GR7, GR8, GR9, GR10, GR11, GR12, GR13, GR14, GR15, GR16, GR17,
GR18, ;
GR19, GR20, GR21, GR22, GR23, GR24, GR25, GR26, GR27, GR28, GR29, GR30,
GR31 ;
, GR32
SELECT 3
USE MAINT.DBF
SET FIELDS TO ONEEIGHTYD, NINETYDAY, MISSCLASS, MISSDRIVE, CANCEL,
DRIVIEPAY ;
, CLASSPAY, SECTPAY, STPAY, DETPAY, TAFPAY, TAPAY, OFFICEPAY,
SRDRIVEPAY, ;
TRADRVPAY, REGPAY, ADULTDRVPA, FEDERALTAX, FICATAX, MEDICARETA, HS1,
HS2, ;
HS3, HS4, DISCOUNT, FIXEDPRICE, NAME, PHONE, LICENSE, ADDRESS, CITY, ST,
ZIP ;
, SCH_DIR, FIRST_CLS, NUM_CLASS
SELECT 4
USE DRV_TIM.DBF
SET FIELDS TO DRVTIMES
SELECT 5
USE DISCNT.DBF
SET FIELDS TO DISCOUNT, REASON
SELECT 6
USE CERTIF.DBF
SET FIELDS TO CERTIFICAT, TAKEN, STARTISSUE
SELECT 1
GO TOP