Jump to content
Sign in to follow this  
Kball1

Want to Omit <No Access> Records

Recommended Posts

Hello. I am a brand new FileMaker Pro user coming over from a Microsoft Access background. I am having an issue with an application that I have created. Through security and privileges I have managed to control the records that a user can view / edit, but I have not found a way to get rid of the records. My application has a field called "Created_By" that captures the account name of the user that creates the record. In security / privileges I use a "Created_by= Get (Account Name) to restrict the records that can be viewed / editied.

I actually have the application set-up so a supervisior can see their records and their direct reports' records. Everything I am doing is working with the exception of being able to eliminate the records. The no access records are also messing up my report.

Any help would be greatly appreciated.

Thanks

Share this post


Link to post
Share on other sites

Perhaps this thread could be of help to you.

thread

Share this post


Link to post
Share on other sites

Just about any option that creates a found set of records will filter out those arecords for the active Account. Try a find based on the Account name, for example.

Steven

Share this post


Link to post
Share on other sites

How do I make the FIND based on the account name run automatically - say when they push a button? I know how to accomplish it manually. I have been playing with various scripts, but have not had any luck.

Thanks

Share this post


Link to post
Share on other sites

Well you can use the scripted find steps. Or you can set a global field to the Get(AccountName) value and do a go to related records based on that global value. Either approach will filter out the records that would otherwise be available.

Steven

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.