I am new to Access and I am trying to update our existing database. Presently our database is used to report incidents that have multiple subjects per incident. Is there a way to have a field recognize the data ie. the last name of an individual, and automatically fill in the remaining fields...