AnsweredAssumed Answered

Limit records access in related tables

Question asked by disabled_leecy on Feb 11, 2014
Latest reply on Feb 12, 2014 by disabled_leecy

Title

Limit records access in related tables

Post

     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

Outcomes