3 Replies Latest reply on Jul 31, 2015 7:11 AM by philmodjunk

    Record Access

      Title

      Record Access

      Post

      Hi All,

       

      I'm trying to set up an privilege set that a user will see only his/her created record on the database. I have two Tables Users Table and Product Table

       

      My Users Table Fields Information

                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       
      FieldsTypeComments
      UserIDNumberIndexed, Auto-enter serial
      AccountNameText 
      CreationAccountTextCreation Account Name, Can't Modify
      First NameText 
      Last NameText 
      FullNameCalculationFirstName & " " & TextStyleAdd(LastName; Bold)

       

      Product Table

       

                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   
      FieldsTypeComments
      ProductIDNumberIndexed, Auto-enter serial
      Products_UsersIDText 
      Product Name  
      Product Lot No.  
      Product Code  
      Quantity Received  
      Supplier  
      Received Date  

       

      My Two tables are connected by UserID  = Products_UsersID

       

      I Created a Privilege Set Which I called Limited

       

      This is What I set Up

       

                                                                                                                                                                                                                                                                                                           
      Privilege Set Name (Limited)Description
      Records (Custom Privilege) 
      Layouts (All Modifiable) 
      Value Lists (All Modifiable) 
      Scripts (All Modifiable) 

       

                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     
      Table NameViewEditCreateDeleteField Access
      Users-----
      ProductsLimited ( IsEmpty ( Users::AccountName ) or Users::AccountName = Get ( AccountName )IsEmpty ( Users::AccountName ) or Users::AccountName = Get ( AccountName )Yes-all
      [Any New Table]----none

       

      Im trying to Log in to my Account Rosalie but not allowing me to create a record to my Product Table.

       

       

      Thank you.