Yes you can so what is the question?
Name table
ID I (unique number)
Name C(50)
Other table
iName I
Field1
Field2
Field3
>I have a field with struct
>
> Name:
> Field1:
> Field2:
> Field3:
>
> I have many repated names
>
> Carl
> John
> Carl
> Moses
> Carl
> Etc.
>
> I need
> Summarize to a table with unique names
> Carl
> John
> Moses
> Etc.
>
> And put field1, field2 and field3 into another
> table
>
> Then I just create a relation
>
>
> Moises
Caroline