Thanks for the tip. I was getting very frustrated with the field-level security and was thinking I would have to customize the part maintenance form for each group. I hadn't thought of creating a BPM.
I am using 8.03 so no extended properties for me. Thanks again for the help.
Rob
I am using 8.03 so no extended properties for me. Thanks again for the help.
Rob
--- In vantage@yahoogroups.com, "Brian W. Spolarich" <bspolarich@...> wrote:
>
> Unfortunately that's how field-level security works. Its
> all-or-nothing, not read-vs-write. You have Extended Properties under
> E9, but not in V8.
>
> You could do this via a BPM: On Part.Update, you'd have two
> conditions:
>
> Where user is not in security group x
> And
> Where number of rows in query is 1
>
> The query would be:
>
> Find each part where part.company = ttpart.company and part.partnum =
> ttpart.partnum and part.character01 != ttpart.character01
>
> (which basically means that the transaction would modify character01)
>
> The action would be to throw an exception, which would make the field
> unmodifiable.
>
> Otherwise you could do something via client-side customization that
> would need to determine the user's group membership and set the state of
> the associated control to disabled.
>
> -bws
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of rob.sample@...
> Sent: Monday, January 31, 2011 2:37 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Restricting Write access to custom text boxes while
> allowing all Read access
>
> I have added a custom text box to the Part Maintenance screen and linked
> it to part.character01 and everything works great. Where I run into
> issues is when I try and use field security maintenance to limit which
> users can write to these text boxes. As soon as I uncheck "allow access
> to all groups/users" and select certain users, the custom text boxes do
> not display part.character01 contents for users who are not in the
> "selected groups/users". These boxes just show up empty. I want
> everyone with access to part maintenance to be able to see what is in
> part.character01 but want to limit who can write to that field. Any
> ideas what I am doing wrong?
>
>
>
> ------------------------------------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
> have already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder
> and Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>