I have created tables for our customers and the text messages we send/receive through our landline texting service.
I built the parent/child relationship but have found that when a new record is added to the text table, it automatically creates a new customer. Some texts are with vendors and the occasional inbound spam. They don’t need to be added to the customer table. Is there a way to only link to existing records vs automatically creating a record. Orphans are ok in this scenario.