thanks michel,

i found another way, i'll compare it with your suggestion.
am wonder what the pros/cons of each are IYHO, of course.

>>Is it possible to create dynamic SQL on the fly ...
>
>You can put everything in a variable lcSql and execute it with &lcSql.

at this point i've got an 2-d array populated with potential field names (col1) of the table register and their values(col2).

FOR len
m.&laRegister[m.i,1] = laRegister[m.i,2]
NEXT

...
INSERT INTO register FROM MEMVAR


tia, kim