Hi Romark,
drag the Appointment.patienstno to index PatientsNo
Parent Alias - Appointment
ChildAlias - Patients
ChildOrder - PatientsNo
relationalExpr - PatientsNo


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