How can I set Primary field on an imported file
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.