Auto Enter Data Based On Another Field
So, I am transitioning from an excel spreadsheet, and there was stuff we tracked on multiple spreadsheets, and I am consolidating it into multiple tables.
We have 300 people, and I have a "family" table where each person can be assigned to a family.
Is there a way to initially set a person's family as their last name? I know I will have to go through and clean some up (differentiating different Smith families, etc), but it will save a ton of time to initially set it, because probably 90%+ will simple be the person's last name.