AnsweredAssumed Answered

How can I set Primary field on an imported file

Question asked by NormanSaxon on Nov 24, 2013
Latest reply on Nov 25, 2013 by NormanSaxon

Title

How can I set Primary field on an imported file

Post

     I am very new to FileMaker Pro 12 Advanced.

     I am having a challenge with setting up primary keys.

     I have two Excel spreadsheets that I have opened in FileMaker

      

     The file come for a server and no data will be edited it is purely read only.

     The commend field is the student number in both tables.

     The student DB has one recorded per student

     The ClassList has student course and student number only

     I need to set up one to many each student cold have many courses

     I guess what I’m asking is how do I set the student number as a primary key?

     I need to be able to pick the class number and list all the students in that class.

      

Screen_Shot_2013.png

Outcomes