1 Reply Latest reply on May 27, 2009 5:00 AM by Jade

    Constrain a Table to One Record

    obeechi

      Title

      Constrain a Table to One Record

      Post

      How does one constrain a table so it can have only one record? 

       

       

        • 1. Re: Constrain a Table to One Record
          Jade
            

          One can set the the 'Create' pop-up menu in the users' privilege to 'no' for the table in question.

           

          Edit the account privilege set (or create a new one) for the users and set the Records pop-up menu to 'custom privileges'.  Then you can choose the table and set the Create pop-up menu to 'no'.  (You may also want to set the Delete pop-up menu to no as well.)

           

          Add a single default record using the admin account. 

           

           

          Alternative:-

           

          You can make all the fields in the table globals.  But this may cause problems in a multi-user solution.