As far as I can tell, Agnes gave you the best answer, but of course her initial SQL statement merely duplicates your original table but with possibly different field names and a new table name. I agree with Agnes that you need tables with a common field in order to do the relation, but I have a problem understanding the need to create a new table identical to the original table. Why do you really need two new tables?

Alan

>Thank you Caroline
>But I think I mistyped my question
>
>I need sql command to create 2 new tables from my table
>
>I have a table with struct (4 fields)
>
> Name(field1)
> Field2
> Field3
> Field4
>
> I have many repated names (field1)
>
> Carl
> John
> Carl
> Moses
> Carl
> Etc.
>
>
> I need I new table for name (without repeat names)
>and I new table for field1, field2 and field3
>
>Moses