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

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

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

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