Can anyone tell me if what I want to do is possible?
I have attached a portion of my database. if you go into the form called frmtest, select a branch from the very top drop down, select a detail and click the Edit button.
I can't figure out how to have the information populate all the fields...