AnsweredAssumed Answered

Record Access

Question asked by disabled_rosalie on Jul 30, 2015
Latest reply on Jul 31, 2015 by philmodjunk

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.

Outcomes