new/edit FORMs should show and update columns linked to related foreign data as users select values in the lookup field

for instance a teachers list with a lookup column for their Dept ID and related Dept Title. As one goes to add a teacher, new form should display the Dept ID lookup column and Dept Title AS WELL and as user chooses a Dept ID and leave the field to another, update the related displlay-only Dept Title column with correspondent data of the chosen Dept ID.