I’m trying to figure out how to combine different contact information for a single person in one record. So, I have one table where all messages to a person is logged: sometimes it will be an email or a phone number. I have a separate record where the primary key is the persons name and that record includes their email and phone number.
If I want all instances of a person’s contact info to be included in their record in the contacts table, how do I combine them?
So, everytime a message is sent to their email or phone, when I click on their contact record i would see it all in their one record.
Thank you and let me know if I can clarify