>create table mytable(no n(3),(thisform.text1.value) same field type ,text2 type,.........etc..,flag n(2),n_try(3)) >>
lcMacro = [CREATE TABLE MyTable No N(3)] FOR lnFor = 1 TO 15 && Instead of 15 put the actual number of TextBox controls you have in form IF PEMSTATUS(thisform,[TextBox]+TRANSFORM(lnFor),5) WITH EVALUATE([thisform.TextBox]+TRANSFORM(lnFor)) IF NOT EMPTY(.Value) lcMacro = lcMacro + [,] + ALLTRIM(.Value)+[ TYPE_OF_THE_FIELD (LENGTH_OF_THE_FIELD)] ENDIF ENDWITH ENDIF NEXT lcMacro = lcMacro + [, Flag N(2), N_Try N(3))] &lcMacro