>hi all,
>
>i want to add at my table the records have myfield char1="121" and not all of this records just ex.. 100 record randomly from char1="121" ,after that appen new records,change char1 to char1="324" with 150 records randomly etc...
>
>i'll try with this code but i get errors.
>any help ,idea
>

>USE newamar66
>SET FILTER TO char21=(thisform.text7.value)
>USE toto
> Append From ('newamar66') next(thisform.text8.Value)
>

>thanks.

The APPEND FROM command supports a FOR clause so try something like

USE toto
APPEND FROM newamar66 FOR char21=ThisForm.text8.Value

There are problems with this if you have deleted records so another approach might be

SELECT * FROM newamar66 ;
WHERE char21=thisform.text7.value;
INTO CURSOR tmpAppend

SELECT 0

USE toto
APPEND FROM (DBF('tmpAppend'))
USE IN newamar66
USE IN tmpAppend