How to update name fields from related table along with autonumber

[Zak14]

The "PersonalDetails" table is related to the "Application" table using the autonumber from table, "PersonalDetails".

The "PersonalDetails" table has "StudentID" (autonumber), "First Name" and "Last Name" fields.

The "Application" table also has "StudentID", "First Name" and "Last Name" fields.

The "Application" table is related to the "PersonalDetails" table using the "StudentID" field.

How do I make it so that the first and last names on the "Application" table are automatically updated when the StudentID is entered?

Thank you.

 

[DavidAtWork]

If you already have name details in the PersonalDetails table, it wouldn't be considered good practice to have the same details in the Application table in a relational database, all you should need is the StudentID.
You may want to reconsider your database design

David

 

[Zak14]

You're right. There's little point in doing this. Thanks anyway.