AnsweredAssumed Answered

Editing Releated Records in Form View

Question asked by CharlesBlackwell on Nov 20, 2013
Latest reply on Nov 20, 2013 by CharlesBlackwell


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?