2 Replies Latest reply on Nov 9, 2015 11:22 AM by kjw282

    Question about Display Data From

    kjw282

      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.