AnsweredAssumed Answered

Auto Enter Data Based On Another Field

Question asked by RichardAdams on Oct 2, 2012
Latest reply on Oct 2, 2012 by philmodjunk


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.