I'm really getting very very frustrated and my mind is blowing like a pressured hot pot. I'm getting a hard time binding my two tables. Patients.dbf and Appointment.dbf
Fields in Patients.dbf are:
pname C 20 ; patientsno C 4 ; contactno C 11 (INDEX) PatientsNo Candidate patientsno
Appointment.dbf :
patientsno C 4 ; apptdate D 8 ; From Date/Time ; To Date/Time ;Treatment M
(INDEXES) PatientsNo Regular patientsno and Schedule Regular apptdate
Are my Index correct sir?
Now My form: Theres txtDate, txtName , txtFrom , txtTo , edbTreatment
dataenvironment i chose Appintment.dbf then added Patients.dbf drag the patienstno to index PatientsNo
Is This Correct?
And in my next button coded:
SELECT(ThisForm.Tablename)
IF RECCOUNT()<>0
SKIP 1
ENDIF
IF EOF()
MESSAGEBOX("LAST RECORD REACHED!", 0+64, ThisForm.CAPTION)
GO BOTTOM
ENDIF
ThisForm.REFRESH()
I made a new property named tablename where i put Appointment.Dbf
Why is it that whenever i click next button , only txtDate , txtFrom , txtTo and edbTreatment moves. All are fields inside the Appointment.Dbf while txtName don't move that is inside the Patients.dbf ?
Sirs could you pls help me with this Two tables in one form , i can't really control the form and my thesis' deadline is two days from now.. Help me graduate. I love Visual FoxPro but I think Visual FoxPro doesn't love me.. huhuhu... Pls... Tnx You...