Hi all,
I using IWP for a database that contains a field called private. I created a script that omits records "Private="Yes"", so whenever the database opens the script runs. The problem is that I need certain users (Engineers) to have access to all records when viewing the data on the web and Non-Engineers (Consultants) to only view public records (non private). I tried creating a password that only displays "Limited" records, but when the database opens it runs the password criteria , then the script runs returning a No Access message in all the fields. It's conflicting since the password criteria "Browse records is limited to "Private="No"" and the script criteria is Omit Records "Private="Yes'". Still trying to figure out a method here where certain users can view certain records, Help anyone!?
-Ralph [color:"blue"]