>CLOSE ALL >USE salah2 >SET FILTER TO no=20&&lnoffice = junk.no >COUNT TO s >*brow >SELECT DISTINCT no,dept FROM salah2 WHERE no=20 INTO CURSOR mycur >*brow >m.dept=dept >m.no=no >*? dept,no >COUNT TO k >*? k, s,dept,no > > USE mytable > APPEND BLANK > replace no WITH m.no > replace nam WITH m.dept > > replace dis WITH k > replace all WITH s > ***************************************************************** >CLOSE ALL >USE salah2 >SET FILTER TO no=42 >COUNT TO s >brow >SELECT DISTINCT no,dept FROM salah2 WHERE no=42 INTO CURSOR mycur >brow >m.dept=dept >m.no=no >*? dept,no >COUNT TO k >*? k, s,dept,no > USE mytable > APPEND BLANK > replace no WITH m.no > replace nam WITH m.dept > > replace dis WITH k > replace all WITH s >*********************** >CLOSE ALL >USE salah2 >SET FILTER TO no=...etc >. >. >. > >