AnsweredAssumed Answered

Easiest (and non-techie) way to relate two fields?

Question asked by LMac on Mar 30, 2016
Latest reply on Mar 31, 2016 by dsvail

Hello:

 

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:

Screen Shot 2016-03-30 at 3.19.06 PM.png

Enrollment details are captured through a layout called Classes and stored on another table similar to the contact list (above):

Enrollment.png

 

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.

 

Thank you.

 

Lara

Outcomes