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