How to get data to automatically enter in multiple tables
Hello. I'm new at this and am having a hard time finding answers in the forum because I'm not using the right phrases to ask the question.
I would like to have the system set up so that when I start a new record, the email, first name and last name fields are automatically filled in across five tables. I tried setting up a relationship based on the main table (Contact Record) that is based on the email, but that didn't work. I tried setting up a value list but that didn't seem to work either. I tried setting up the Look Up but that didn't work either. Can someone direct me in the right direction?