Jump to content
Salesforce and other SMB Solutions are coming soon. ×



Recommended Posts

Hi guys. I posted an earlier thread asking for help with passwords in file maker 5. Since then i've managed to upgrade to file maker 8.Anyways i'm designing a database for a school. Wherein the teachers are required to input information about their classes into a page that is exclusively theirs (namely individual records of a particular layout) . So basically I want to know how to set a password for individual records. How do I go about doing this in file maker pro 8? Thanx for your help.

Link to comment
Share on other sites

Hi, burno_06.

Create Global field Teacher_Password.

Create self relation from this field to Teacher_Id with allowing create record.

Then create layout with portal of this relation.

Each teacher must know only his ID and put it in Teacher_pasword field.

This field must be up of portal.

After putting each teacher in the portal will se only his records.

In this way you dont need password.

Link to comment
Share on other sites

Use the built-in accounts and passwords. This is what they're there for. In the privilege set definition, you can setup Custom Records access, and define record level access (RLA) privileges. One of the rules for your Enrollment table's RLA can be that Teacher::Classroom = Enrollment::Classroom, or something similar.


To streamline the user interface, you'll probably want to store the current teacher's ID or Classroom in a global so it can be used as a parent key in a filter to show only those Classrooms/Students that that teacher has access to.

Link to comment
Share on other sites

This thread is quite old. Please start a new thread rather than reviving this one.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Create New...

Important Information

Terms of Use