thank you,

i try it i get error message syntax error at &lcMacro

i stop it as *&lcMacro, and run it again no error

i fetch for new table(mytable) but nothing happend.







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