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?