I have a database that I am working on where I list an item that is in a particular program and that program is assigned a division. When I select the drop down box to select the program, I want it to autofil the field of Division with the division that this program is assigned to. I have a table which lists an ID number for the program, the program name and the division. I have a relationship connecting the main table with the program table and the Program field displays data from the Programs table. I just do not know how to have it populate the Division Field in the main form. Can someone tell me how to do that?
Thank you in advance.