Limit access by user in specific record submission

2 posts by 2 authors in: Forums > CMS Builder
Last Post: November 10, 2011   (RSS)

By nmsinc - November 9, 2011

I’m setting up users to have access to only certain company files. When the user is setup in the account record, I choose the company they will have access to from a drop-down list populated from a separate company record listing.





This user now has the ability to add records to another section that also has company names in the drop-down list populated from the separate company record listing.



I need to restrict “Author View” and “Author” users choice in the drop-down to that which was setup in the user file only. Editors need to see and choose from all companies listed.



Any help would be very appreciated - Thanks - nmsinc[/#000000]
nmsinc

Re: [nmsinc] Limit access by user in specific record submission

By Jason - November 10, 2011

Hi,

It sounds very similar to this post:

http://www.interactivetools.com/forum/gforum.cgi?post=90736#90736

You would just have to change "createdByUserNum" to the name of the field in the section you're pulling the record from that would match the record in CURRENT_USER.

Hope this helps
---------------------------------------------------
Jason Sauchuk - Project Manager
interactivetools.com

Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/