4 Replies Latest reply on Nov 25, 2013 7:04 AM by NormanSaxon

    How can I set Primary field on an imported file

    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