Limit records access in related tables
I am new to FM 13. I have created a Student Table with First and Last Name Fields. I want selected users to be able to add new records with student names in them. I have related the Student Table to a Course Table. The two tables are related through the ID fields.
Desired Scenario: I enter new records into the Student Layout. I enter course data related to each student into the Course Layout, but I don't want anyone to be able to change the student names in the Course Layout. The related ID field works fine but the Student Names allow entry changes.
I have tried prohibiting access to the Name fields, but when I do, I can't enter new records into the Student table. Hope I'm making sense.
Help is appreciated. Thanks. Leecy