My form is based upon my table tblPreliminaryBonus
This table has various fields, but the ones I'm interested in is:
I have an unbound text box label txtDM used only for information and is not enabled. I am looking for a way to get the First Name of the District Manger that is associated with Store and display that name in the text box txtDM
Currently, when I select a store it displays the FK for that district manager, where I need a name instead.
I've attached a copy of the db with the form in question. Although there are 3 other employees shown on the form when I get the DM I'll do the rest. StoreBonusRevX.mdb