October 13, 200619 yr Hi oh ye gurus. In FM6, I had a handydandy little feature which prevented records from being accidentally modified. A record was "locked" (a field called locked was set to "yes" when the record was locked), and while that field was set to "yes" the record could not be edited. If someone wanted to edit the record he would first explicitly haveto unlock the record by clicking an unlock button (field is now set to "no") and now you could edit it. After the edit the user must again explicitly press a button to lock the record. It is very handy to avoid accidental modifications of fields if someone for example spills his beer all over the keyboard. This was simple enough as in FM6 you could in the priveleges say that you can "only modify the record under certain conditions" and in my case that condition was that the field "locked" is set to "no". Worked like a charm. Problem: In FM 8.0v1 (my version) that seems to be no longer possible to tie access privileges to field conditions. Any ideas on how to simply implement this in FM 8.0v1 on a record by record basis? Much obliged, the wumpus
October 13, 200619 yr This still can be done in pretty much teh same way as before. This can be done at either the record level or the field level by setting the rule in the Record Level Access definition of the Priviege Set or in the field validation section of Define Fields. Also, please update your version to 8.0v3. Steven
Create an account or sign in to comment