"Is using a find script for each user/group the only way to make groups of records disappear"
It's probably the easiest way. I can imagine a way to use Go To Related record to do this, but don't see any advantage to that approach.
I'd keep all the records in one table and use scripts to control what records a user can see.
You can use script triggers to automatically filter out records to hide the no access records from a given user.
You can even write scripts and use a custom menu so your scripts can replace items such as Show All Records with a modified version that hides the no access records and the user won't see any difference except for the clutter you've filtered out.
The interface details take some work, but with persistance and a bit of creativity, you can do this.
I am using FMP 10. How can you filter out the results that say "no access"? Can you be more specific on how to filter out the records that say "no access". Each user logs into the database using their own account and password. Users are accessing through IWP
Any find you perform, even a bogus one, automatically omits records to which the user does not have access. Same with portals. The only problem is with Show All Records - you want to remove this option from your users.
How can I write a find command that uses the " Get(AccountName) " command?
It would be great if the layout would only show the records where:
table::ContactAccountName = Get(AccountName)
But I can not enter this into a find command, or am I missing something?
You'd do it like this:
enter find mode
Set field [table::ContactAccountName ; Get(AccountName) ]
Set Error Capture [on]
perform find 
Thank you for the scripting help. I am experiencing a problem with the script. I have the script set to a button on one layout. When I click on the button, the cursor goes to the one field that is present on the layout and the script stops. Does that make sense? One of the primary uses of this script is IWP. I am using FMP10
I re-examined my script, made an adjustment and what you wrote functions perfectly! Thank you for the help.