I'm not sure why you are getting the greyed out menu options here.
To filter out the "no access" records, just perform a find in a script that runs when the file is opened or when the layout is first entered. Any find will do as "no access" records will automatically be excluded from the found set. Thus a find performed with a "find all" kind of criteria is all you may need for this.
Enter Find Mode
Set Field [Yourtable::AnyneverEmptyField ; "*"]
Set Error Capture [on]
Once this script is performed, the only way your users will see "no access" records is if they choose "Show All records" or "Show Omitted Only", And custom menus ( Requires FileMaker advanced ) can even be used to change those results to keep "no access" records invisible.
thanks heaps worked a treat.
In regard to the greyed out sections
When this user logs on he is now seeing only the projects he had entered earlier. However the New Record and Delete record buttons in the top task bar are greyed out and the user cannot enter any new projects. In fact everything is greyed out except for the record selectors.
OK the user is attached in manage / security to the privilege set I created called teamView
Team View has the following features -
Data Access and Design:
Records - Custom Privileges
All others - All Modifiable
All other Areas
Records - Custom Privileges features:
Everything is Yes and All except for the table 'Projects' which has it's VIEW field set to 'limited' (rest of it's fields are yes and All.
Calculation in regards to the table Projects - "Record_Created_By = Get(AccountName)"
In table projects there is a field called "Record_Created_by" which is automatically filled by whoever created the project with their account Name.
So this process all works fine except for the greying out
Thanks in advance
One situation that can grey out menu options is if a script is running--either in an infinite loop or one that is currently paused. You can check the status area to see if a "continue" button is showing as one will appear if there's a paused script.
Just one possibility that comes to mind.
there is no continue button running or showing.
Buttons greyed out are -
Show All / New Record / Delete Record / Find / Sort / Edit Layout / View As / Preview
The record selectors are not greyed out however they are showing filtering ie 1/2 a green circle showing 2 of 5 records.
Any other ideas
Do you see the same options greyed out on every layout?
What options did you select for this privilege set in the Other Options section? Especially the "Available Menu Commands" section?
The available menu commands were set for minimum. I just switched to All to test and they are all free to use. So happy days.
Thanks for the help.