Get table values in a many to many relationship

[Khalil Handal]

Hi,
I have a many to many relationship between the following tables:
tblBibli with 43000 records
NewTable is the junction table with 62000 records
The NewTable has two fields: FamilyName and FirstName (with duplicates)

How can I create the third table tblNames that contains no duplicates names in order to continue the N:M relationship?

Here is a picture of the relationship until now:



Here is also a sample data from the junction table:



Thanks

[pbaldy]

Your pictures didn't come through. Try attaching here, if you tried to link.

[John_G]

Before you do that, I suggest that you do not rely on the combination of First Name + Last Name to be unique - many people share the same first & last names, so you should look for another way to uniquely identify your authors (I assume it's authors).

[orange]

AlternateNames of what, you will want/need a a separate table(s)