6 Replies Latest reply on Nov 20, 2013 11:38 AM by CharlesBlackwell

    Editing Releated Records in Form View



      Editing Releated Records in Form View


           I have two tables (Student and Mentor) and I would like to place the name, using a field calculation, of the mentor on the student for and allow for it to be selected via drop-down. The relation is based of a numeric id field but I would like the name in the field without duplicated it. I could use a value list but that would put the value in the table many times and I just want the id in the field to associate a mentor with a student.

           What should I do?