I am having an issue with adding new records to a table when the first name is the same as a record that already exists.

Situation:

Table A has firstname = Emily & lastname = Ping

Table B has a lookup field to pull in the firstname + lastname (Emily Ping) from Table A

I am able to enter new records in Table A that have the same firstname = Emily with a different last name...say lastname = Richardson

However, when I try to make a new entry in Table B for 'Emily Richardson' it automatically changes 'Emily Richardson' to 'Emily Ping'

Can someone please help??!  Thank you!