I am creating a data base that keeps track of students and the classes they are taking. The student's details are stored on a table (?) called, Contact List:
Enrollment details are captured through a layout called Classes and stored on another table similar to the contact list (above):
Once a student registers, enrollment is just a series of dropdown boxes.
Is there a simple way to auto-populate a student's number (the box to the right of Stefano Mathias) once the user chooses a name? I am not very versed in FMP and the relationship creation, and in fact, it's difficult for me, but I am happy to learn if someone has the patience to give a step-by-step. If there is an easier, step-by-step, I would appreciate it.