Paul,

The code below will populate table3 based on table2

SELECT Table2
SCAN
    FOR ix = 2 TO FCOUNT()
	lcVal = EVAL(FIELD(ix))
	IF NOT EMPTY(lcVal)
		INSERT INTO Table3 (Emp, Fld1) Values (Table2.Emp, lcVal)
	ENDIF
    ENDFOR
ENDSCAN

>Cetin
>
>Thank you very much,
>
>I tried it and works fine but I have another question:
>
>How to convert from TABLE2 TO TABLE3 to have many records like :
>

>TABLE2 :
>
>EMP#   B1     B2     B3    B4   ............B....
>
>00001  A1X    A2X    A3X    -
>
>00002  A1Y    A4Y     -     -
>
>TABLE3 should have many records for the same emp#
>
>emp#
>
>00001  A1X
>00001  A2X
>00001  A3X
>.
>.
>00002  A1Y
>00002  A4Y
>.
>.

>I really appreciate if you could help me out.
>Thanks in advance.
>Paul
> < SNIP >