4 Replies Latest reply on Feb 1, 2012 7:16 AM by karendweaver

    Read Only Field/s

    rtentinger

      I need to make some fields from a related table read only?

        • 1. Re: Read Only Field/s
          timwhisenant

          Hi,

           

          In layout mode, select the field, open the inspector, go to the data tab, uncheck the Browse Mode check box under Field Entry

          • 2. Re: Read Only Field/s
            karendweaver

            Tim is correct as far as it goes - but the field will NOT be read only using this method - only the field on the specific layout will be read only - the user can still make changes to the field on any other layout that has the browse mode option checked, or using a script step of set field whether or not it is  on a layout.

             

            The best thing would be for you to explain in detail what you want to accomplish.  Is it read-only only for certain users?  only under certain conditions?  what is hte nature of the data you are trying to protect?  How will the data be entered if the field is read-only??

             

            If you really want to make a field read-only under any circumstances, there are several ways to do it.

             

            1.  You could make the field a calculation.  Then the contents of the field can be changed only if the criteria for the calculation changes.

            2.  You can set the field to View Only access in the user privilege set.

            3.  You can put a validation in the field definitiion, so that it is only editable if certain conditions are met

             

            If you can provide some additional information, we can probably help you more..

             

            warm regards,

             

            Karen Weaver

            • 3. Re: Read Only Field/s
              rtentinger

              Thank you for responding.  The setup for this layout is main/primary table

              used for collection of data, the relational tables are to allow choices for

              the selection of data.  For this entry it is attendance.  Instructor enters

              ID, child table should display From a Course Table: Periods, Course ID,

              Description, Room, etc. >> upon selection the Course IDPeriod should

              populate Primary Table.  I did try Tim's response but the whole group of

              listed records select.

               

              From:  karendweaver <noreply@filemaker.com>

              Reply-To:  <fmi-311131638-hbm-2-1h46@fmdev.filemaker.com>

              Date:  Tue, 31 Jan 2012 13:05:33 -0800

              To:  Student User <rtentinger@gmail.com>

              Subject:  Re: Read Only Field/s

               

              <https://fmdev.filemaker.com/index.jspa>

              created by karendweaver <https://fmdev.filemaker.com/people/karendweaver>

              in Advanced Discussion - View the full discussion

              <https://fmdev.filemaker.com/message/68838#68838>

               

              Tim is correct as far as it goes - but the field will NOT be read only using

              this method - only the field on the specific layout will be read only - the

              user can still make changes to the field on any other layout that has the

              browse mode option checked, or using a script step of set field whether or

              not it is  on a layout. The best thing would be for you to explain in detail

              what you want to accomplish.  Is it read-only only for certain users?  only

              under certain conditions?  what is hte nature of the data you are trying to

              protect?  How will the data be entered if the field is read-only?? If you

              really want to make a field read-only under any circumstances, there are

              several ways to do it. 1.  You could make the field a calculation.  Then the

              contents of the field can be changed only if the criteria for the

              calculation changes.2.  You can set the field to View Only access in the

              user privilege set.3.  You can put a validation in the field definitiion, so

              that it is only editable if certain conditions are met If you can provide

              some additional information, we can probably help you more.. warm regards,

              Karen Weaver

              Reply to this message by replying to this email -or- go to the message on

              FileMaker Technical Network

              <https://fmdev.filemaker.com/message/68838#68838> Start a new discussion in

              Advanced Discussion by email

              <mailto:discussions-community-discuss-advanced@fmdev.filemaker.com>  or at

              FileMaker Technical Network

              <https://fmdev.filemaker.com/choose-container!input.jspa?contentType=1&conta

              inerType=14&container=2068>

                                      Manage your email preferences

              <https://fmdev.filemaker.com/index.jspa/user-notification-preferences!input.

              jspa> .

               

              FileMaker Developer Conference 2012 € Miami, Florida € July 16-19 €

              www.filemaker.com/devcon

              • 4. Re: Read Only Field/s
                karendweaver

                It sounds like Tim's response will meet your needs - you are only trying to prevent data entry in the portal rows except for the course id.

                 

                But it sounds like you really have another, much more basic problem with the relationship itself.  When you say the whole list selects I am not sure exactly what you mean - are you entering a course id in a portal record?  Or in the parent record?  what is the parent?  is it attendance or something else?  What is the exact relationship you are using?

                 

                Normally - you would at least have something like a student table, a course table, a registration table (join students to courses) and an attendance table with records for each student attending each course - as another join between student and course or possibly linked to the registration table (off the top of my head).  If this does not sound anything like what you are doing, then you need to take a closer look at your relationship structure.

                 

                Karen