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...