>hi,
>
>i have just 2 tables ,table1 with all data1,
>table2, i insert what i choice in table2,
>
>i need to delete just from table1 ,
You can delete from whatever table you like. The table names I provided were just an example.
>about pk,most of all fields duplicated at table1,
Each table should have a primary key, so that you can easily refer to a specific record - as you need to do now.
IIRC, my article on primary keys includes an example of how to assign a sequential number to each record.
You can sometimes use recno() instead of the primary key, but this will cause you numerous problems in the long run. I strongly suggest you create a specific field for the primary key.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)