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