>hi all,
>
>is there a way to create new table after i choice fields from ather table,
>
>via my form i can drage (choice) any filed and insert it at text1 or text2 or text3... etc.
>
>i need to create table first field as (no.) the laste 2 fields as flage and n_try this 3 fields need it every time, other fileds it is be as what i drag(choice) at text1,text2....enclude the same type....etc .
>
>
>

>create table mytable(no n(3),(thisform.text1.value) same field type ,text2 type,.........etc..,flag n(2),n_try(3))
>

>
>thanks.

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