I have successfully set this up for my table -
However, I do have one glitch that I'm hoping for some advise on.

When I am in the form and make my selection for "Principal", I am
immediately sent to the very first form record.
If I navigate back to the new record and do not change the "Principal"
selection, then I can continue to enter data and the two fields that update
from "Principal" do show the correct selections.
If the "Principal" selection is changed here, then I am sent back to the
first record once again.

In the After Update line of Principal, I have simply "Requery".
(I have tried with no luck to go into the "Requery" macro and specify the
specific fields that I want to requery - not sure if this is related to my
issue here.)

Thanks again for any suggestions/tips/etc.