SET DELETED on SELECT TAlias1.employeeid,TAlias2.nam,TAlias2.nam4,TAlias1.workdays,TAlias1.absencewp,TAlias1.absencew,TAlias1.uovertimeh,TAlias1.whovertime,TAlias1.vacations,TAlias1.sickvacati,TAlias2.wark ; FROM payroll TAlias1, mstr TAlias2 ; WHERE TAlias1.employeeid = TAlias2.no ; ORDER BY employeeid ; INTO cursor mycur readwrite COUNT TO thisform.text2.value thisform.Grid1.RecordSource=" mycur" thisform.Grid1.refresh()**at thisform.Grid1 event afterrowcolchange&&
>>**afterrowcolchange >>thisform.text1.Value=thisform.grid1.column1.text1.value >>thisform.text3.Value=thisform.grid1.column11.text1.value >>thisform.text4.Value=thisform.grid1.column4.text1.value >>>>thanks