My first post...geez...this is unnerving...feeling all veclempt. :-)
I'm desiging a db for a coworker for our MedStop Physicians. I have a refTbl of Phy_ID, LNAME, FNAME ...so when she's entering a physician's time in the Work Detail Form (tblWorkDet) and she chooses the Phy_ID from a combo box I want the fields LNAME and FNAME to automatically populate based on her choice.
Thanks for any help you can provide.
Amy