So I have a database for entering records. Each entry must include in it the person entering the record along with which division, unit and team they are currently assigned to. The tricky part is that people change division, units, and/or teams all the time. I need some general advice at how to go about designing the database so that a person can enter in their id number, name, division, unit, and team once and whenever the open the the database that information will automatically default into the form. Additionally, they must be able to change the information when they change division, unit or team and update the defaults. What I hope to come up with is a way when the person opens the input form they can type in their id number and pull their name and current assignment (division, unit, team) and that information will be pass into the new record when they enter it. They also must be able to update their information when they are reassigned. Help